|
|
How to unhide and pictures in excel by
TUNGANA KURMA RAJU
In one of my w/books I used McGimpsyes's macro "Looking up and displying
pictures based on a cell value",http://mcgimpsey.com/excel/lookuppics.html
,by...
|
|
1 |
162 |
|
|
Run macro on exit by
Steve
I have a multi-sheet document. Before I exit I like to click box A1 in all
sheets so that when I open the document everything is all neat and tidy and I
know...
( 1 2)
|
|
12 |
188 |
|
|
|
October 25th, 2009 09:21 AM
by Mike H
|
1 |
129 |
|
|
|
|
1 |
112 |
|
|
Recalculating Subtotals by
Haryadoon
Subtotals (and autosums) don't change when you add a new row at the bottom of
the range. In both cases, the Excel function will generate a formula for
you,...
|
|
2 |
107 |
|
|
Look Up and provide multiple result by
nsd
Hello again,
I tried to post this, however I don't find it under my postings, hence
sending it again.
---
I have a worksheet in the following...
|
|
4 |
167 |
|
|
How can i use > in lookup function? by
AZHawkPilot
Column B has dates, 1 Jan 05 through 31 Jan 06. Column E has numbers .1,.2,
up through 6. I need a lookup function that will find the last value in
column E...
|
October 25th, 2009 01:32 AM
by smartin
|
3 |
137 |
|
|
|
October 25th, 2009 01:05 AM
by smartin
|
1 |
124 |
|
|
|
October 25th, 2009 12:51 AM
by smartin
|
1 |
119 |
|
|
|
|
1 |
99 |
|
|
|
|
2 |
160 |
|
|
|
|
2 |
91 |
|
|
|
|
1 |
83 |
|
|
Excel 2007 Track Changes problems by
Auntie
I have a shared Excel file which I created in Excel 2003. The worksheet has
hidden columns and requires my users to filter and sort the data. The
problems...
|
October 24th, 2009 03:14 PM
by Auntie
|
0 |
123 |
|
|
hyperlink by
calvin
how can i get hyperlink to just find the file and not ask to open it?
i just want to find the file so i can just delete it
|
|
1 |
78 |
|
|
Combine Formulas by
Canon
Excel 2007
I have a simple formula; =sum(E3/22.40), and I would like to combine the
FLOOR function together with this so that the answer rounds down.
4.4689...
|
|
1 |
96 |
|
|
|
|
2 |
109 |
|
|
EXCLUDE TOTAL FROM FILTER by
Dave
Hi
I am trying to create a row which will only sum whatever is in a filtered
columns.
Can this be done??
|
October 24th, 2009 01:07 PM
by Pete_UK
|
7 |
115 |
|
|
A vlookup/index-match type problem by
Andrew Mackenzie
Hi all,
I hope someone can help me with this. I want to return a value from a table
which is based upon two criteria. I have a table like this:
A ...
( 1 2)
|
October 24th, 2009 10:24 AM
by Bernd P
|
10 |
180 |
|
|
|
|
1 |
92 |