|
|
Which function do I use? by
Zong
Workbook with 2 spreadsheets. I need to look up a part number in one column
and have it give me the value in another column on the same row.
PS# ...
|
February 22nd, 2009 11:20 PM
by T. Valko
|
7 |
77 |
|
|
Special today Date challenge question by
ZONNET
What I want is have a today function eg in cell A1.
based upon entering any text in for eg b2, puts me the julian dat in cell
A2, So far, so good, I got that...
|
|
1 |
397 |
|
|
|
|
1 |
92 |
|
|
Excel drag down formula not working good.. by
zoola
hi,
i have a formula
=IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0)))
when i drag...
|
|
1 |
74 |
|
|
vba excel macro question...ranges by
zoola
Hello,
I have been asked by a friend to help with vb/excel, however i have not
touched vb in my life. I have a background in c/c++, so if someone could
point...
|
|
3 |
144 |
|
|
Excel drag down formula not working good.. by
zoola ander
hi,
i have a formula
=IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0)))
when i drag...
|
|
0 |
72 |
|
|
Excel drag down formula not working good.. by
zoola ander
hi,
i have a formula
=IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0)))
when i drag...
|
|
1 |
68 |
|
|
Need Extra Help by
Zoom
I need help out there.
I have the following string 698 2071264621559589
I want the result to be as follows:
"698","2071","2646",21559589
Thank you very much
|
September 16th, 2004 03:47 PM
by JBoulton
|
2 |
118 |
|
|
worksheets by
Zoom on Sheets
How do I change the "zoom" on all the excel sheets at one time?
|
|
2 |
76 |
|
|
|
|
1 |
90 |
|
|
|
June 21st, 2005 04:01 PM
by zooming
|
2 |
277 |
|
|
Setting Up A formula For A Time Sheet by
zooming
I have setup a column with a list box that includes several project headings.
I have also setup a list box that allows you to select the amount of time...
|
June 27th, 2006 08:13 AM
by zooming
|
4 |
111 |
|
|
Budget Set Up by
zoomzoom632
Please view my Excel files to better understand what I am talking about...
http://www.geocities.com/bushiebrow2000/Fall_2008_Budget_Test_Sample.xls
On the...
|
|
9 |
102 |
|
|
Number Order by
zoomzoom632
I want to take a list of numbers and sort them using functions in another
column
Sheet one,
Column A: a bunch of numbers in a random order.
Column B:...
|
October 14th, 2007 12:42 AM
by Pete_UK
|
5 |
59 |
|
|
Informational Search by
zoomzoom632
Here's the Senario,
Sheet One Contain the Results of a Race:
Column A: Racers Name (in ABC order)
Column B: Their Hometown
Column C: Their Time
Column D:...
( 1 2)
|
|
17 |
205 |
|
|
MinMax Buttons by
zoot
Hello All,
I hope this is a stupid question!! Can you not set minMax properties on an
excel form....I can not find it in the properties window...did I turn...
|
|
2 |
63 |
|
|
Moving to Previous Worksheet by
Zootie
Is there a quick way to open the last worksheet you had open prior to the one
you are currently viewing, and toggle between the two sheets? I am looking
for...
|
October 4th, 2006 03:28 PM
by PCLIVE
|
1 |
61 |
|
|
|
|
5 |
91 |
|
|
SUMIF function problem by
Zorba
I have used this formula in the past (last month) without problems - now I
have copied the columns and tried to alter the formula - it keeps telling me...
|
|
6 |
149 |
|
|
|
April 16th, 2009 06:36 AM
by ZorionK
|
3 |
86 |