|
|
Summing random cells as you click on them by
Ben in CA
I need to create a "program" with an Excel document that allows me to click a
button like "start adding" and then I can click on random cells (well, they...
|
|
6 |
109 |
|
|
Pairwise comparisons? by
Donal P[_2_]
Is it possible to use Excel to perform pairwise comparisons? I'm trying to
force stakeholders to express their preferences for a handful of limited
options...
|
|
1 |
115 |
|
|
|
|
1 |
143 |
|
|
If statement using time of day by
BAKERSMAN
I need to have E2 return a specific value based on the time of day.
If E2 is greater than or equal to 0600 but less than 1800 then I need to see
shift 1
If...
|
|
3 |
81 |
|
|
|
|
1 |
93 |
|
|
Protect cells by
cockatoo
My spreadsheet has columns A-N. I need to protect Col A-G & L so users can
enter data only in Col H to K and Col M & N, and restricted to alter data in
Col...
|
|
2 |
94 |
|
|
Large Workbook - trouble opening by
rbecker
I have a couple of workbooks (Excel '07) that I'm having trouble with them
being slow to open. One, I sort of understand why it's slow as it has a lot
of...
|
December 8th, 2008 08:00 PM
by rbecker
|
5 |
80 |
|
|
|
December 8th, 2008 07:59 PM
by Bobc
|
0 |
100 |
|
|
move cursor in excle using macro by
fdibbins
ok, sounds dumb, but how do I move the cursor in excel a set number of lines
using a macro - cant use a cell reference because it changes all the time. I...
|
|
6 |
106 |
|
|
fill in text from another cell by
Godspeed
I am working on an inventory of equipment, and have a dropdown for the make
of equipment, and would like to have the model cell populate with the model...
|
|
1 |
114 |
|
|
radio button does not copy to e mail by
Wanna Learn
Hello I am using "Mail Selection Range Outlook Body" CODE from Ron De
Bruin . I have radio buttons on the worksheet and the radio buttons do not
copy to...
|
|
1 |
108 |
|
|
cumulative total by
T McShu
I have a client who wants me to include on his monthly invoice, every
consultant who has worked on the contract, the number of hours each
consultant has...
|
December 8th, 2008 07:45 PM
by T McShu
|
0 |
100 |
|
|
Interesting Median observation by
Bony Pony[_2_]
Am I going crazy?
Create 16 values so that the formula
=median(a1:a16)
does not return the value of an actual cell you have typed.
Now use
=median(a1:a16,1)
|
|
8 |
186 |
|
|
Rounding Up or Down to nearest $10 by
jeffc4442
I need to round the results of a sum up/down to the nearest $10. i've been
looking in excel help and also online discussions. i've found a lot of
answers,...
|
|
3 |
75 |
|
|
Using Or in an If statement by
Jase
Can I write and If statement saying
"If citeria is matched or_
citeria is matched or_
citeria is matched then
do something
end if"
Can you...
|
December 8th, 2008 06:54 PM
by Bob I
|
5 |
132 |
|
|
how to convert excel data into picture by
Kirk
How would I convert values in an excel spreadsheet into a format that an
image viewer could use? Example: 0-255 values in a table into 0-255
grayscale...
|
December 8th, 2008 06:47 PM
by Bob I
|
3 |
334 |
|
|
|
|
2 |
113 |
|
|
Conditional Formatting by
Auz
Please can someone help me
i created a spreadsheet in Excel 97-2003 that uses conditional formating to
show progress, red no green yes and was saved as...
|
|
1 |
93 |
|
|
Tab, "up" and "down" arrow keys in Excel by
JEG[_2_]
I created a spreadsheet to track my job hunt. When I hit the tab button, it
jumps from column A to column R. When I use the up/down and left/right
arrows, it...
|
December 8th, 2008 06:36 PM
by FSt1
|
2 |
124 |
|
|
Mouse won't scroll thru worksheet by
vnsrod2000
Hopefully this is a simple problem...
I'm using Excel 07 and the wheel won't scroll though my worksheet. It works
in all my other MS programs, and it works in...
|
|
3 |
109 |