|
|
Sorting data within the same row. by
aequanimitas
I have devised a Cash flow template which I now need to be able to sort date
in the same row for so it can automatically calc brough t fwd invoices paid
and...
|
|
1 |
79 |
|
|
Lookup Function by
Aequo79
I'm using a lookup_value,lookup_vector,result_vector function as an array
formula to lookup first and last names in a two column array table and locate
their...
|
|
1 |
69 |
|
|
|
April 16th, 2006 09:52 AM
by MartinW
|
1 |
59 |
|
|
|
|
1 |
112 |
|
|
|
|
2 |
51 |
|
|
Dates by
aeroman55
How can I return a date, six months plus the first of the following month
from a specified date? In other words, both January 1, 2005 and January 31,
2005...
|
|
2 |
105 |
|
|
|
March 29th, 2006 06:18 AM
by Biff
|
1 |
112 |
|
|
|
|
2 |
59 |
|
|
|
|
3 |
97 |
|
|
|
|
1 |
94 |
|
|
Linking cells in a workbook by
aet-inc
Hi:
Can someone please explain to me how to do the following?: I have 2
sheets (Sheet1 & Sheet2) in the same workbook.
I want cell A1 of sheet1 to always show...
|
December 2nd, 2003 01:37 AM
by aet-inc
|
0 |
215 |
|
|
Count text cells based on two criteria by
aet999
I have a spreadsheet with many columns. I would like to count how many
occurances there are of two criteria matching. Example, If column A contains
names of...
|
|
9 |
111 |
|
|
|
|
6 |
314 |
|
|
If Function Function by
aetejada
okay. So I am trying to workout a formula to compute a commision earning.
Basically, if X amount of new business is made, then X*Y (corresponding
Commision...
|
|
1 |
161 |
|
|
Combo Box Properties by
Aex de Silva
Hi,
When adding a combo box for example, to edit the data source you need to go
to properties. Somehow I've manged to change the format which I see...
|
December 28th, 2005 10:38 PM
by PCLIVE
|
1 |
59 |
|
|
File placement with copied sheets by
AE[_2_]
I have a spread sheet built that currently has 382 sheets of data. The sheets
are 12 columns x 61 rows. There are conditional formats applied. I can copy a...
|
May 31st, 2010 03:04 PM
by Mike H
|
1 |
844 |
|
|
|
October 25th, 2006 09:15 PM
by AF
|
0 |
96 |
|
|
Lookup by
AFA
Hi,
Country Month Value
Germany 1 100.00
Germany 5 250.00
UK 7 400.00
Spain 2 300.00
UK 5 250.00
Germany 9 710.00
|
|
3 |
48 |
|
|
Double Lookups by
AFA
Hi
Country Product Value
Germany Car 1,500.00
Germany Bike 200.00
Japan Bike 300.00
Japan Van 2,500.00
Japan Car 10,000.00
Based on the above...
|
September 19th, 2007 03:53 AM
by Max
|
3 |
53 |
|
|
Logical Test by
AFA
I have extracted text data format thus i cant perform any maths calculation
on the data. Thus i tried this logical test to convert the data into number.
cell...
|
May 13th, 2008 02:56 AM
by AFA
|
2 |
90 |