|
|
Multiple Sumif conditions by
Alcala
Hello and thank you in advance for your assistance.
I am trying write a formula for the following calculationj:
In column B i have the initials of sales...
|
August 18th, 2008 05:30 PM
by Alcala
|
2 |
57 |
|
|
Sumproduct with three arrays by
Alcala
Hello and thank you in advance for your assistance.
I have a spreadsheet as follows:
Column C= Revenue
Column D= Units
Column E = Months, as a number (i.e....
|
December 13th, 2008 01:26 AM
by Alcala
|
2 |
54 |
|
|
Creating Visual Excel Cell Alerts by
alchemist
Hi there guys,
I'm relatively new to this but would appreciate your help.
Basically what I am trying to do in excell to create visual alerts in
the same cell...
|
|
5 |
167 |
|
|
|
April 21st, 2005 05:40 PM
by Alcide
|
2 |
234 |
|
|
Counting characters within a cell by
Alco Engineer
In order to help update an existing spreadsheet, I want to be able to count
either the number of numbers in a given cells, or alternatively the number
off...
|
November 4th, 2008 07:08 PM
by Spiky
|
5 |
79 |
|
|
|
|
2 |
88 |
|
|
|
|
5 |
161 |
|
|
|
|
2 |
336 |
|
|
Pivot Table categories by
Alder
If I have a datalist like the following, is it possible to produce a
pivot table with a single row for each unique combination of values in
column A and B? ...
|
August 18th, 2009 12:30 AM
by Alder
|
4 |
113 |
|
|
Copy Values to next empty cell range by
Aldo Cella
How can I program this? I want to copy c19:g19 on sheet1, to the same sheet,
and paste special(values) to the next empty row in this cell range,...
|
|
1 |
84 |
|
|
Lookup Array Formula by
aldsv
A dozen google searches didn't solve this problem, but I know you
can...
I have a row of data (I actually have a lot of rows, and a lot of
columns):
I need...
|
October 25th, 2005 01:45 PM
by aldsv
|
4 |
172 |
|
|
|
|
2 |
124 |
|
|
COPING FULL PAGE PATTENS TO ANOTHER PAGE by
Alec
I'm setting up a yearly spread sheet that has different colour pattens in
different cells etc. I wish to copy the full page patten layout onto the
other...
|
November 29th, 2006 06:10 AM
by Jaleel
|
1 |
80 |
|
|
Date Values by
Alec
I currently have a cell that shows week commencing, ie
Mondays date only for any particular week, I currently
update this cell every week.
I have been looking,...
|
October 31st, 2003 12:11 PM
by Alec
|
4 |
123 |
|
|
Passing Variables into a Link by
Alec
I have written VB code that, on the press of a pushbutton,
creates new sheets from a template, it also puts the sheet
name in cell A1 of the new sheet.
I also...
|
October 9th, 2003 02:12 PM
by Alec
|
4 |
261 |
|
|
vlookup in if by
Alec Green
can you uses vlookup within an if statement, I can both functions to work
separately but not together.
Thanks
Alec
( 1 2)
|
February 22nd, 2006 09:38 PM
by Pete_UK
|
10 |
171 |
|
|
|
|
6 |
299 |
|
|
Detecting Blanks and Non Text Characters. by
Alec Kolundzic
Help
=IF( E61="Cable",Q61,IF( E61
="Terminal",IF(ISBLANK(Q61),"",CONCATENATE($R$17," ",Q61)),""))
The above function concatenates the contents of R17 and Q61...
|
|
4 |
119 |
|
|
Highest Number Offsets by
Alec Kolundzic
Can anyone help;
I'm trying to find the highest number in a column, then
copy that number and the data in the cells of the next
two rows into three adjacent...
|
|
4 |
113 |
|
|
Highest Value by
Alec Kolundzic
I'm looking for a function that will find the maximum
value in a column, then will put that value in a cell
( 1 2)
|
|
17 |
194 |