|
|
Seemingly impossible task by
fluffy
In the example below I am trying to determine the rows that contain duplicate
account numbers. I am thinking that if I could do an IF/AND function I could
get...
|
September 16th, 2005 05:52 PM
by fluffy
|
2 |
96 |
|
|
|
September 16th, 2005 05:58 PM
by MDOTJR
|
2 |
221 |
|
|
|
|
2 |
127 |
|
|
|
|
3 |
106 |
|
|
|
|
3 |
210 |
|
|
Unlock, locked spreadsheet by
Matty B
I have a spreadsheet that I created a while ago, and have just gone back
into it. I have password protected the spreadsheet before I last left
it, and now...
|
September 16th, 2005 06:20 PM
by MDOTJR
|
2 |
101 |
|
|
Format a Cell from VBA by
Bill Martin
I've got a macro that does a bunch of things and at the end puts a number value
in a cell. I would like to write out that value to be displayed in a...
|
|
4 |
104 |
|
|
text color by
bassfisher
hello everyone, i was wondering if there is a way to change the color of
text in the active cell only! i know that the background color can be
changed in...
|
September 16th, 2005 06:25 PM
by MDOTJR
|
5 |
112 |
|
|
listbox by
Greg B
I have a listbox which I am listing cells a1:a1000 on a worksheet called
"homes". I would like the ability to have the user highlight the item in
the list box...
|
|
4 |
108 |
|
|
cant email workbook thru excel by
jaredwetmore
I have an workbook that just wont email thru excel.
As far as I can tell there are no special formatiing, and its a small
workbook.
others files work...
|
|
2 |
95 |
|
|
Permutation in excel by
Sweden
Hallo!
I´me a new member in your forum, can somebody help me to solve this
problem in excel please:
I need to make combinations with a makro or a funktion in...
|
|
4 |
133 |
|
|
Formula when adding rows by
Andy Brander
I have a simple table where data is gathered from another worksheet (lets
call it WS2), the formulas look something like:
Col A Col B Col C ...
|
|
3 |
88 |
|
|
Its a wild one, maybe. by
comotoman
Can i use an if statement to use a picture as a result?
--
comotoman
------------------------------------------------------------------------
comotoman's...
|
|
1 |
78 |
|
|
|
September 16th, 2005 07:31 PM
by Julian
|
2 |
247 |
|
|
|
|
3 |
466 |
|
|
Formula to calculate over-time by
Debbie Mack
I am trying to set up a formula to calculate my over-time. I want to set up
if number is greater than 9, 9 goes to regular time and balance to overtime
and if...
|
|
1 |
67 |
|
|
Its a easy dumb question. by
comotoman
When i have formulas with there criteria not fullfilled, i get the
"#N/A". How do i get that to go...
|
September 16th, 2005 08:57 PM
by Alan
|
7 |
263 |
|
|
Counting Problem by
peter_rivera
Hi everyone,
My problem is with the COUNTA funciton. I have a formula,
"=IF(COUNTA(K4:Q4)0,1,0)", set up so that if at least one cell has a
letter/value,...
|
September 16th, 2005 09:19 PM
by Domenic
|
1 |
88 |
|
|
Sort by grouping by
rreneerob
I have a spreadsheet that needs to be sorted. However, some of the rows need
to be grouped and sorted with its heading row. How can I do this?
Renee
|
|
1 |
86 |
|
|
|
|
2 |
193 |