|
|
|
|
1 |
49 |
|
|
|
|
1 |
42 |
|
|
Another way to lookup data by
David Vollmer
I need another way to take the contents of two cells (City and State) and go
find whether they exist on another workbook that contains a sheet for each
state....
|
September 23rd, 2005 05:16 AM
by JMB
|
1 |
171 |
|
|
sequential counter by
David Webster
I have a column of species and a row of plots as follows:
PLOT: 1 2 3 4 5
Spp1
Spp2
Spp3
Spp4
Spp5
....
to Spp 150
|
September 17th, 2003 07:34 PM
by 2rrs
|
4 |
301 |
|
|
MouseClick as Counter by
David Webster
Is there a way to add code so that you add one to every cell you click on
within a range?
E.g. any cell between say C3 to H20 when I clik it I want it to...
|
|
1 |
324 |
|
|
Applying module to startup by
David Webster
I have created an Application.OnKey code that maps PasteSpecial to F15 but I
want it to work every time I open a new spreadsheet when I start up. How is
this...
|
|
1 |
137 |
|
|
applying macro to startup by
David Webster
Hello
I created a code in a module that allows me to map Paste Special Value to
F15. I want this macro to automatically start when I load any new...
|
|
2 |
371 |
|
|
A formula to discount percentage by
David Wilson
I am trying to find a formula to discount by percentage rather than currency
on Excel 2007.
Example:
A1 B1 C1
£25 ...
|
|
4 |
78 |
|
|
percentage formula by
David Wilson[_2_]
can someone give me a formula to dicount by percent.
Example:
A1 B1 C1
£50. -33% £33.50
...
|
|
3 |
95 |
|
|
How to show two students have same result? by
DAVID Yii
How to show that two or more students having a same CGPA?
If there are 100 students,then the top of 2 students have the same CGPA,by
ranking they both are Num...
|
November 19th, 2008 01:21 PM
by vezerid
|
6 |
70 |
|
|
|
July 12th, 2006 11:36 AM
by Pete_UK
|
2 |
73 |
|
|
Recalculation taking a massive 11 seconds by
David.Allen297
Hi,
I've designed a simple spreadsheet that's looking at a small table of
data and returning 2 values.
(The sheet gets updated by external means, hence I'm...
|
|
2 |
73 |
|
|
Recalculation taking a massive 11 seconds by
David.Allen297
Hi,
I've designed a simple spreadsheet that's looking at a small table of data and returning 2 values.
(The sheet gets updated by external means, hence I'm...
|
|
0 |
85 |
|
|
|
|
5 |
106 |
|
|
|
|
1 |
82 |
|
|
|
|
1 |
56 |
|
|
Looking up non-unique data by
david1
I haven't had to do this for so long that I've forgotten how, so memory
jogs would be appreciated.
Assume datalist subset: A1:A10 =...
|
January 20th, 2006 01:41 AM
by Domenic
|
1 |
55 |
|
|
|
December 15th, 2005 03:36 AM
by Biff
|
5 |
139 |
|
|
|
|
0 |
86 |
|
|
Easy quesiton: Text sorting. by
david987
I'm just wondering how can I make text to be sorted from the right to
left...
Instead of having:
Hello
Example
One
Have:
|
|
1 |
145 |