|
|
IF Statement by
Kiley
I have one row for each person for the following IF Statement to look at. Is
there a way to add a "lookup" to the IF Statement to look at a particular...
|
May 21st, 2009 12:53 AM
by Max
|
1 |
160 |
|
|
copy formula up by
Pammy
Is there an easy way to copy formulas up without dragging up? I have a
spreadsheet that has 4500 rows of info, I want to add the latest infor at the
top...
|
|
2 |
151 |
|
|
|
|
4 |
161 |
|
|
|
|
1 |
172 |
|
|
|
|
1 |
254 |
|
|
|
|
1 |
176 |
|
|
v look value dependant on 2 cells by
Tacklemom
what I am trying to do is calculate a formula based on the following:
what I am trying to do a generate a V look up dependent on 2 cells
I need to look at...
|
|
2 |
169 |
|
|
How reference cell in different worksheet by
laavista
I’m comparing values in worksheet 2 against values in worksheet 1. Once
found, I put the cell,column info in the 2nd worksheet indicating where it
was...
|
|
7 |
194 |
|
|
Help on lookup functions by
Scott
I have a chart with anywhere between 1 to 12 columns, and anywhere between 1
to 144 rows. The columns used are anywhere between K-V, and rows range from
5...
|
|
2 |
157 |
|
|
NumberFormat by
danpt
Range("A1:E3") contains 1 to 4 digits arithmetic numbers.
I want to format the range in "0000" format and still retain its
arithmetical properties.
This macro...
|
|
3 |
161 |
|
|
Figuring out hours worked by
Matt
In cell F3 I am trying to get the hours work from the start time in cell D3
and the finish time in E3. I can not locate the forulma for this?
|
May 20th, 2009 10:42 PM
by Matt
|
3 |
170 |
|
|
Data Import Question by
Steve Haack
I need to import data into Excel for statistical analysis. The data is being
collected from thousands of PC's in an organization. Each of them generates a...
|
|
2 |
196 |
|
|
SUMIF and Named ranges by
Henry
How can I get this formula to work. The idea is to create a dynamic formula
where the it sums a range based on the date as it changes each month....
|
|
3 |
150 |
|
|
Equation by
MDL
I need an equation in a cell (P4) that will depend on:
1) if the dollar amount is under $200,000 (in cell F17), the number I need
in cell P4 will be .0075 of...
|
May 20th, 2009 10:18 PM
by MDL
|
4 |
162 |
|
|
|
|
3 |
166 |
|
|
merge cell is disabled by
Fesco
how will I enable merge cell and other toolbars. the file was shared and
tried to save as and make another name but still can't make it unshared.
What will I...
|
|
1 |
153 |
|
|
.xlsx by
at22
How do I open OpenOffice docs in Office (.xlsx for example)
|
May 20th, 2009 10:15 PM
by Bob I
|
1 |
158 |
|
|
|
|
1 |
245 |
|
|
|
|
2 |
186 |
|
|
|
|
1 |
134 |