|
|
Insert Row Selection by
VLOOKUP fORMULA
Any one please help me.......?
After inserting row how can I go back to the row I selected for inserting,
instead for going to A1
Sub...
|
|
2 |
136 |
|
|
Look up? by
Caroline
Hello,
I have a simple table: header row is clients, 1st column are employees. Each
employee is assigned a primary client and 1 or more secondary clients....
|
|
3 |
161 |
|
|
Lookup by
VLOOKUP fORMULA
Any body pls help me.....?
Sheet1
A B C
Name Rank Company
Romeo Painter PWD
Patrick Carpenter ABC
Sheet2
|
June 18th, 2009 10:19 PM
by brett
|
4 |
146 |
|
|
Function on "Text to Columns" by
Nandeesh
I have list of Names for e.g.
Antony, John - 30022275
David, Joan - 30022277
When I used "Text to Columns" function I am able to saparate Names in
different...
|
|
4 |
182 |
|
|
|
|
1 |
169 |
|
|
Replace #/Div by
Alfred90210
Isn't there an 'Excel Option' that allows you to enter value (Free Text... IE
N/A) when you get a #/div error?
I know that pivot tables have that option, but...
|
|
6 |
207 |
|
|
|
|
8 |
194 |
|
|
|
June 18th, 2009 07:45 PM
by LindaR
|
5 |
131 |
|
|
Lookup functions by
Ted
I have a spreadsheet I am trying to build that has 3 tabs. The first are my
employees and thier statistics by week. What I want is on my second tab to
be...
|
June 18th, 2009 07:28 PM
by JCS
|
1 |
126 |
|
|
please your help by
BIRNET
How can I use as a criteria dates between a start and end dates in sumif
function.
I wand to sum B cells if dates in A are between 1/1/2009 and 31/3/2009.
|
|
1 |
98 |
|
|
How do I associate text with a number? by
JJA
I have a list of thousands of employees with a security clearance number
between 1 to 20. I now need to substitute that number with a position or
title. ...
|
|
1 |
171 |
|
|
|
|
2 |
162 |
|
|
IF Statement not working by
steve12173
I have an IF Statement to give me a number based on sum of another cell. It
looks like this: =IF($B$54000000, "0",...
|
|
7 |
123 |
|
|
|
|
3 |
119 |
|
|
|
|
7 |
197 |
|
|
|
June 18th, 2009 05:55 PM
by DSKR
|
4 |
109 |
|
|
Rank - Change the Rank of a Tie by
jackie
+Hi- I have set up a rank using a standard ranking formula. I have a total
of 156 items that I am ranking. The values of the rank range from -660 to
756. ...
|
June 18th, 2009 05:41 PM
by Luke M
|
1 |
150 |
|
|
|
June 18th, 2009 05:38 PM
by amuw
|
0 |
104 |
|
|
IF AND MATCH data type issue by
EZ[_2_]
This formula is working fine, except that my data is imported from MS Access
and Excel seems not to recognize the correct data type.
I have two data sets...
|
June 18th, 2009 05:35 PM
by EZ[_2_]
|
2 |
120 |
|
|
|
June 18th, 2009 04:42 PM
by DLS
|
0 |
143 |