|
|
vlookup from multiple sheets by
Radhakant Panigrahi
i have data in 10 different sheets (Sheet 2 to Sheet11)with identical columns.
i need to use the vlookup function in Sheet1 taking the range from column E
to...
|
|
2 |
285 |
|
|
|
|
2 |
234 |
|
|
Function Has Too Many Arguments by
tb
I am using Excel 2007 for Windows.
Excel complains that one of the functions in the following formula has too
many arguments. I am not quite sure which...
|
May 19th, 2010 02:26 AM
by tb
|
4 |
225 |
|
|
|
|
8 |
280 |
|
|
|
|
2 |
330 |
|
|
Sorting columns into a table by
Christian
Hi,
I need to sort the following data in A2:C8 to E2:G8 (actually there are 40
rows of data). The date needs to be sorted to Low risk first (then mid and...
|
|
6 |
311 |
|
|
MLK b-day as holiday date by
Greg
hi,
i need a function to calculate what date would be the 3rd monday in January
for a given year. can this be done w/o arrays?
thanks
--
______
Regards,
|
May 18th, 2010 11:32 PM
by Mike H
|
5 |
152 |
|
|
|
May 18th, 2010 11:29 PM
by BDF
|
0 |
183 |
|
|
Pivot Item Displaying Incorrect Value? by
mark
We have a pivot table, which has Project as pivot field 4.
The Project pivot field has 3410 pivot items, of which number 842 is
misbehaving.
The project...
|
May 18th, 2010 10:36 PM
by mark
|
1 |
181 |
|
|
|
May 18th, 2010 10:35 PM
by Billns
|
3 |
229 |
|
|
|
|
1 |
174 |
|
|
how do I attach a jpeg to a cell by
Mark
I am trying to have a button or link in a cell that when clicked will open up
a jpeg that is also attached to (part of) the excel file.
|
May 18th, 2010 10:33 PM
by Billns
|
1 |
172 |
|
|
|
|
2 |
151 |
|
|
|
|
2 |
207 |
|
|
Calendar Control missing by
deafo
Giday to you all, I'm trying to help fellow worker who have Excel 2003
and he does'nt have Calendar Control in Object dialog box.
Even his computer in...
|
|
4 |
236 |
|
|
Find 3 If(Iserrors instead of 1 by
Steve
I posted this a week ago, and did get a couple of responses, but they did not
work. So I'm trying again, thinking that the wealth of knowlege here is such...
|
|
7 |
222 |
|
|
Max Function by
Iriemon
Is there any function available that works similar to the MAX function for
alpha characters?
Thanks
Irie
|
|
3 |
158 |
|
|
|
|
2 |
149 |
|
|
using a conditional in STDEV function by
Researcher
I would like to use the STDEV function on a set of cells that have been
indicated by a conditional statement. I have tried a variety of ways and have
not...
|
|
1 |
146 |
|
|
Include YTD calculations? by
MrRJ
Hello,
I have built a table with formulas similar to this. I need assistance on
how I can create a YTD table based on what Period I...
|
May 18th, 2010 08:33 PM
by MrRJ
|
4 |
127 |