Archive by month February

Total hours between two time slot

I am trying to find a way which can calulate number of hours between two times. Not sure if there is a way to do it it in excel? I have one column with time ( …

value conditional on multiple criteria

I have a database of annual salary costs based on country and post level on one exel tab. There are 2700 rows (based on 18 posts levels across 190 countries). …

VBA Finding the next empty cell

I apologise I am starting to learn VBA – very slowly! My proble revolves around two worksheets: “Front Page” and …

Formula for 2 different dates

Hi All,   I need to be able to search data were we have 1 client with multiple expiry dates of policies.  We need to pull the data of the oldest …

How to unhide a range of cells instead of entire row?

Hello, I’ve created a timeline tool where the left side of the excel sheet is the internal inputs timeline and from there it spits out a summarized …

How to unhide a range of cells instead of entire row?

Hello, I’ve created a timeline tool where the left side of the excel sheet is the internal inputs timeline and from there it spits out a summarized …

Text to Value Summation

Here is what i am trying to do….is there one formula that would work? In J2, I want to sum L2:R2 where the value of any text is = to ‘1’ …

Formula Mining

I have a lot of formulas, which means I want to know what they said and for what it is done. like :-  =LOOKUP(Answerkey[[#This …

Formula Clarification

QNTY PIECE MARK SIZE DESCRIPTION LENGTH LENGTH TOTAL LENGTH (FT) FT IN FT 1 1C1 W8X21 COLUMN 4 4.375 4.36 4.36 1 1C2 W8X21 COLUMN 4 4.375 4.36 4.36 5 …

Count of duplicate items – Need Help!

I have a situation where i am supposed to take a count of only unique value from the sheet (excluding one value repeating in different months) and i am …

highlighted cells

I have cells that have an iteam description in them depededing what the are I have highlighted them. for exmaple all iteam that are plastic are …

Manipulate data in excel to order results per a certain column

Hi,   I want to make the information in some columns (but not all) displaying in rows, please see below an example.   This is what I have:   …

Insert Row Shortcut?

I am trying to paste in something from another sheet. I went to that sheet, copied the cells. Went back to the original sheet and, to make a row for the cells, …

formula help

I’m tryint to fiure out a formula for a spreadsheet.  I need the formula to add the number purchased in e2 to be multiplied to the \$ value in …

functions

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be …

excell help

I WANT TO GENERATE RECEIPT FOR HOME[RS.100] WHICH CONTAIN LAND[RS.60] AND CONSTRUCTION COST [RS.40]. WHEN I RECEIVE RS. BELOW 60 ,MENTION”LAND”,AND …

Merging two datas in excel

Hi, I am working on a project that requires me to merge two datas in one. I am currently inserting cells then copy pasting the data, which requires a …

Copying fields into other worksheets

I have 2 worksheets. One is just a templete of what i want to copy over from the other worksheet. The other worksheet has over 900 rows. i want to transfer …

Formula required

I am using Excel 2010 and could you please help me with the following request.   Suppose A1 to E1 each contains as follows:   A1 CAT  …

VBA Find Sub

I need a VBA sub that will use the title of a sheet to find the matching text on another sheet and use that text as reference to retrieve other data in the …

Multiple IF to work out sum in table

I am trying to creeate a spreadsheet which will work out a certain value for myself.  I am trying to figure out how I can do the following: If (such a …

Creating an excel formulae with multiple options

I am trying to creeate a spreadsheet which will work out a certain value for myself.  I am trying to figure out how I can do the following: If (such a …

How to make an object move according to value within a cell

Hello,    I would like to know to make an Object move up to varying points (Left and Right), depending on date values within specific cells.  …

Combining functions

Hi, Im trying to comfine a COUNTIF and IF function into a single cell. Indivudually, the functions work, but I just needthem to work together Im scoring …

3D heat map visualization

I would like to ask for two things How to get a linked image from 3D visualization which change everytime I update the 3D Map How to mangage color distribution …

Excel IF and AND functions trouble

Hello, Well I’m stuck. I’m trying to write a formula using the IF and AND functions that ought to be simple, but just can’t make it work. …

Excel formula question

I have two tabs, lets call them White and Black. In White I will record data, I.E cell A1 is a name, Chris.  cell B1 is a number, 200.  cell A2 is …

double filtration with the last nearest date

I need to filter from two columns (name and date) select the value from a third column. Name can be matched exactly, but the date filtering is more tricky …

How to create a 3D Graph from the following data

I have the following data in a .csv file that I import into Excel, once that is done I need to be able to create a 3D Bar Graph of that data. Date, Time, …

update in one sheet an its automatically updates in the master sheet

i have two sheets one is sample another one is RTF, when i update value in RTF sheet its has to automatically update in sample file, the only thing is , there …

look up text formula

hello, I am having trouble writing out a lookup formula where if a certain text is located in a cell, then i want to look up another value in another …

Count how many times Date appear within a range of Dates (not cells)

Hello, I’ve been trying to search for solution for hours now, and yet still can’t find it. So I really hope someone could help me. So here is what …

Excel expert

I have a 2 rows in excel table.- 1st row is for Month and 2nd row is for score. The table is dynamic that a new month is added after every month. I need a …