Results 1 to 2 of 2
2002-11-23, 06:22 #1
- Join Date
- Jan 2001
- Thanked 1 Time in 1 Post
Up or Down arrow if text in cell (Excel xp)
On the attached worksheet i need to concatenate an up or down arrow depending on a letter that appears underneath the cell and one to the left. Please see the explanation on the data worksheet.
I need to write a formula or macro on the data worksheet since the "csv" worksheet will be updated by cutting and pasting to it every period. Thank you again for the help.
2002-11-25, 22:26 #2
- Join Date
- Oct 2002
- Ross-on-Wye, Herefordshire, United Kingdom
- Thanked 0 Times in 0 Posts
Re: Up or Down arrow if text in cell (Excel xp)
I have to admit to being somewhat confused by your spreadsheet notation. It's not 'All Fools Day' is it?
The following is a somewhat clunky, but working function for the FIRST test you want to perform:
This identifies if there is an "A" in any cell in Column C. If you need to refer to this test/formula several times, then you can put the formula into a single Cell, give that cell a name, e.g. 'ThereIsAnA', now in EACH cell where you want to perform this test, you can write something like:
Replacing the TRUE/FALSE with whatever values/formatting is required.
If you can try re-explaining some of the other tests you want to do, I'm sure there is a way.
Hope this helps.