|
|
If & Vlookup statement by
Sarah
I am trying to lookup 2 separate ranges based on the IF statement.
For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2)
But if B3...
|
April 16th, 2010 08:13 PM
by Mitch
|
3 |
227 |
|
|
networkdays issue by
AJ
This is my Q838 field: 3/3/2010 4:06:08 PM
This is my T838 field: 3/3/2010 8:22:42 PM
This is my function:...
|
April 16th, 2010 07:10 PM
by AJ
|
8 |
213 |
|
|
|
|
1 |
219 |
|
|
Identify the windows just below the menu by
Luismo
I am writing instructions for non-users of excel and need to identify the
windows just below the menu. specifically the one that identifies what cell
is...
|
|
2 |
158 |
|
|
concatenate by
rpmani
I want to combine three cells with 'Concatenate' function and get the result
like
cell A1 = 10 (emp code)
cell B1 = filename.xls
cell C1 = sheet1'!A1
my...
|
|
2 |
146 |
|
|
|
|
3 |
148 |
|
|
|
April 16th, 2010 04:30 PM
by Squeaky
|
2 |
184 |
|
|
formatted cells by
medina
cells are formatted a certain way i.e. with formulas or dates.
On more than one occasion when i close the worksheet and reopen, the cells
are formatted...
|
April 16th, 2010 04:29 PM
by medina
|
0 |
158 |
|
|
Dynamic Filtering...Need Help by
cmeyer
Using Version Excel 2003
I have a report that retrieves different data based of data validation. In
each case there are rows that have no data and I want...
|
April 16th, 2010 04:08 PM
by cmeyer
|
0 |
158 |
|
|
|
|
2 |
153 |
|
|
Formula by
josvill2010
Hi,
I was using Vlookup formulas and now of sudden the formula appears on the
spreadsheed like if it was a text. What can i do to fix that?
--
Thanks for...
|
|
1 |
143 |
|
|
Week ending Thursday formula by
Laurence Lombard
I am looking for an elegant solution for a week end Thursday (or any other
day) formula:
Up to now I have successfully used the following formula for "week...
|
|
4 |
130 |
|
|
|
|
3 |
159 |
|
|
Interval between now and next birthday by
WilDeliver
I need to calculate the interval between a date next year and a person's next
birthday after that. Sorry if this has been answered, but I can't find it. ...
|
|
3 |
173 |
|
|
|
|
2 |
125 |
|
|
comparing data in excel by
Eightball
Using Excel 2003.
I have two columns for each month in a spreadsheet. Column A is the item
code and column B is the cost/item for last month. i then have...
|
|
3 |
166 |
|
|
Sumproduct with a twist by
Pam
Hi,
Per code below supplied by Max in post dated 1/1/09 "Calculating the sum of
different categories over a given time period", I need a slight variation...
|
|
4 |
129 |
|
|
Sum of retuned valus as digits by
Vinay Vasu
Hello there,
I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.
Thank you
Jeevan
|
April 16th, 2010 10:49 AM
by Mike H
|
1 |
162 |
|
|
search a row for a word and if found by
Vibeke
I have 4 columns (C to F) I need to search row by row for a particular word.
If the word is found in a row, I need to return 1 in Column G or 0 if not
found....
|
|
2 |
203 |
|
|
Concentration Analysis by
Phillip Olan'g
I'm analysing a set of data and I need to provide an out put that shows the
count i.e. frequency and the sum. Consider the values below:
local...
|
|
3 |
148 |