|
|
Need help to create a macro by
Igneshwara reddy[_2_]
I am trying to build a macro for an answer sheet in such a way that, it
performs the below functions when I click on the “SUBMIT” . The sheet
contains...
|
|
1 |
146 |
|
|
|
|
1 |
176 |
|
|
Variable Sumproduct Range by
Tony
Hoping someone far smarter than myself can help.
The below formula will give a result where column A=Monday, col B=John and
sum the corresponding values in...
|
|
6 |
194 |
|
|
Sort data separated by commas by
dab
Good day and thanks for reading.
I am working on a file where a cell contains data separated by a comma.
ex:
Col A ...
|
|
4 |
182 |
|
|
editing cells automatically??? by
yogiiyogee
Why is it that some spreadsheets will not allow you to edit cells
automatically when tabbing between windows? i.e. some spreadsheets will
require you to...
|
|
1 |
112 |
|
|
FORMULA'S by
MATTQHL
WHEN DUPLICATING DATA USING =WORKSHEET1!A1, ON ANOTHER WORKSHEET WHY IS IT
THAT IT CAN ONLY DO NUMBERS NOT TEXT I'M SURE THERE'S A WAY CAN ANYONE HELP
THANKS...
|
|
2 |
268 |
|
|
|
|
1 |
147 |
|
|
|
May 13th, 2010 09:15 PM
by KL
|
6 |
161 |
|
|
|
|
5 |
223 |
|
|
RONA Spreadsheet by
Dan
I am in need of an Excel speadsheet that will calculate my company financal
RONA or "Return on Net Asset"
|
May 13th, 2010 08:06 PM
by Brad
|
1 |
200 |
|
|
|
|
6 |
610 |
|
|
convert matrices to table by
Dave
Hi to everyone, is it possible to view a matrix in table mode?
I have a matrix like this
b c d e f ...
b 1 0 3 4 5
c 2 5 8 6 ...
|
|
3 |
143 |
|
|
Formulas to Numbers by
MAD
I am using Excel 2003
I have a price table for each of our products. Ex: Product #xxx - 1 item
cost $100. Price B for 2-5 items cost (=100*.95%), Price C...
|
|
2 |
163 |
|
|
Average with Conditions by
Curtis[_6_]
Source sheet
Column J contains the vlaues for condition 1
Column B contains the values for condition 2
Column D contains the numbers I wish to average
In my...
|
|
1 |
125 |
|
|
Conditional formating dates by
Teeny
I have a range of dates in a column and I would like it if I could highlight
any date that is more that 3 years old.
So if the date reads 02/10/2004 this...
|
|
2 |
114 |
|
|
|
May 13th, 2010 03:16 PM
by CD
|
3 |
167 |
|
|
Grouping and sorting details by
Rich Stone
First time in the Excel Section... Be gentle please!
I have a spreadsheet which lists all visits by all clients. With this
information, I wish to create a...
|
|
7 |
241 |
|
|
Google Adsense Account Approval Tricks by
Adsense Trick
Google Adsense Account Approval Tricks
New Unique Genuine Google Adsense Account Approval Trick Only For Rs.
1000/-.
Take This Trick & Create Unlimited...
|
|
0 |
125 |
|
|
Lookups and ifs! by
Annie
Hi I have the following workbook:
Sheet 1 contains Tax Rates
A1 B1 C1
20% 40% 60%
Sheet 1 further down the sheet contains the following...
|
|
2 |
127 |
|
|
|
May 13th, 2010 12:58 PM
by DKS
|
3 |
200 |