|
|
|
|
1 |
138 |
|
|
Excel 2007 - Autocomplete Alpha List by
Jannoth
In previous versions of Excel, if I added A,B,C,D,E to the first few rows of
a column then dragged the AutoFill handle downwards, Excel would have
recognised...
|
|
4 |
188 |
|
|
|
|
0 |
241 |
|
|
Nesting Lookup Functions by
eionjess
Is it possible to nest an HLOOKUP in a VLOOKUP equation?
Here's what I have: =VLOOKUP(C27,A2:B5,(HLOOKUP(D27+1,INDIRECT(A2),21)
Each VLOOKUP lookup value is...
|
March 25th, 2010 05:29 PM
by Ziggy
|
4 |
154 |
|
|
VLookup with Search for in String by
Benjamin
I need to look for this value within a cell
i.e.
A1XT-4-0713-01-00021-1.PDF
within Folder:Folder:Folder:Folder:FolderPath:A1XT-4-0713-01-00021-1.PDF
then...
|
March 25th, 2010 05:14 PM
by Ziggy
|
4 |
163 |
|
|
SUMPRODUCT help by
Mark D
Good afternoon everyone
I have the following 2 formula's that are working perfectly for me
=(SUMPRODUCT((K9970%)*(B118=1),K78*'Base...
|
|
3 |
129 |
|
|
Repost - Functions on filtered data by
LiAD
Afternoon,
Sorry i forgot to put in the formulas concerned. Second time lucky!
I have an excel sheet of 10 cols and 200 rows on sheet 1.
Sheet 2 has a...
|
March 25th, 2010 04:34 PM
by LiAD
|
0 |
139 |
|
|
Array formula to find date by
Amylou
To trigger conditional formating.
I tried being brief, but I couldn't figure out how and still be articulate.
Each month we publish a catalog of our products...
|
March 25th, 2010 04:17 PM
by Amylou
|
0 |
165 |
|
|
|
|
0 |
168 |
|
|
Macros by
AlwaysQuestions
I have recorded a macro to open up a service report I use all the time. I am
able to open it only when I open Excel for the first time. After I close
that...
|
|
8 |
125 |
|
|
|
|
12 |
369 |
|
|
Formula for multiple countifs by
J.Scargill[_2_]
Hi,
I would really appreciate anybodys expertise with the following 2 formulas;
I have a worksheet that looks a bit like this - (A is days taken to deliver
-...
|
|
4 |
110 |
|
|
Multiple IF function by
Jecker
Any assistance will be greatly appreciated.
I have a worksheet that contains employee information, another worksheet
that contains current team structure....
|
March 25th, 2010 01:36 PM
by Jecker
|
7 |
143 |
|
|
|
|
4 |
151 |
|
|
General Calculator by
MIKEY
Hi all
I have a SUM result in M8 (this is my sub total)
I have a allocated cell Q8 to receive a final Total.
Cells N8,O8,P8 will be allocated the functions...
|
|
1 |
149 |
|
|
|
|
1 |
149 |
|
|
Sumproduct, but errors in column by
ker_01
I've been asked by a colleague to help tally some data, and sumproduct is the
logical formula to use. However, the raw data has some N/A# errors in it, and
I...
|
|
6 |
177 |
|
|
HELP! by
TJ
How can i combine two formulars together?
=COUNTIF(L9:L453,"Deal*")
=COUNTIF(A9:A452,"15/03/2010")
Im trying to find out how many DEALS on a certain date
|
March 25th, 2010 09:21 AM
by TJ
|
4 |
114 |
|
|
IF - more than seven arguments by
Hannah
Good morning
I would like to write an if formula that will provide me with the month (in
words) if the date in a column falls between certain values, this...
|
March 25th, 2010 09:21 AM
by Hannah
|
2 |
130 |
|
|
|
March 25th, 2010 07:22 AM
by Jim
|
0 |
142 |