|
|
Vlookup with If condition by
Biff
I meant this to go under Excel Worksheet Function. My apologizes for the
repeat.
A1 A2 A3
1 3 4
2 5 6
3 6 3
4 7 8
5 ...
|
|
1 |
130 |
|
|
combining dates and text in a cell by
Cecilia
Hello--
I had a column with dates and another with text labels.
I'd like to combine these and tried using this formula:
=D6&" "&I6
D6 = 7/4/2009
I6 =...
|
March 19th, 2010 06:22 PM
by JLatham
|
1 |
144 |
|
|
a Counting question by
cinnie
hi to all
I'm sure this is easy, but I'm new to Excel.
I need a function that will COUNT all the numbers in a range (B5:B1525)
equal to or greater than the...
|
March 19th, 2010 06:08 PM
by cinnie
|
4 |
165 |
|
|
Lookup 2nd & last match with two conditions by
Billy Leung[_2_]
Hello,
I've a table below, I would like to setup a query which could return a value
showing the 2nd match and last match in the next column. Thank in...
|
|
6 |
164 |
|
|
formula required by
Sohail khan
Dera plz solve my problem, i m working in a bank my query is that
Today is 9-mar-10 my ending balance is 10,0000.00 in sheet 1 column A2 . and
this balance...
|
|
0 |
154 |
|
|
|
March 19th, 2010 05:01 PM
by Elgee
|
2 |
151 |
|
|
|
|
2 |
168 |
|
|
Messy Formula needs clean up help! by
Danny Boy
The Formula below works, but feels quite sloppy, and I'm sure it can be
accomplished in a much cleaner fashion. In addition, I attempted to add 1
more...
|
|
7 |
138 |
|
|
Extracting the last word from a string. by
Ciarán
I have a list in excel like the one below.
The filename is always after the last "/".
What formula can I use to extract the filename?
The number of instances...
|
|
2 |
186 |
|
|
|
March 19th, 2010 02:18 PM
by Brad E.
|
2 |
168 |
|
|
|
|
3 |
148 |
|
|
Macros by
Debbie
I'm new at running macros and I currently use the "record macro" button. I
need to run a macro that recognizes "only populated data" in the columns so I
can...
|
March 19th, 2010 01:25 PM
by Debbie
|
2 |
152 |
|
|
|
|
4 |
143 |
|
|
What caused my paste function not to work? by
EXCEL USER
Even I checked the box under tools/edit/show paste button, I can not copy and
paste from one excel workbook or file to another.
How can I make the paste...
|
|
2 |
144 |
|
|
Addition to a working formula by
Scoober
I have this formula and it works fine.
=IF(OR(S140="No",S140="0"),"",G140*X140)
This is placed in cell p159
I now need to add the exact same information as...
|
March 19th, 2010 09:53 AM
by Zoltan
|
1 |
145 |
|
|
Workday function not working by
Cam
Hello,
Why does it returns "#NAME?" when I use =WORKDAY function in Excel 2003?
My formula is =WORKDAY(D4,-B1,Holiday!A2:E109) where D4 is a date and B1 is...
|
|
6 |
154 |
|
|
Electricity Bill Sheet by
XKruodo
Hi,
I posted a similar question 2 days back but seems like i was not clear
enough with the question. The following table contains UNITS of electricity
and...
|
March 19th, 2010 06:22 AM
by XKruodo
|
6 |
149 |
|
|
|
|
1 |
132 |
|
|
paste values Excel 2007 by
Diamond
Is there a way to setup a hot key to paste values in Excel 2007? Also, is
there a way to change the icon buttons?
Thx
|
|
2 |
148 |
|
|
|
|
5 |
152 |