Software

Ask something
Question Locked

MICROSOFT EXCEL 2003

0 helpful
6 replies

by buzby

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can anyone help. IF THE LETTER "A" IS ENTERED INTO A CELL BETWEEN (A1:A40) THEN THE NUMBER Fig"1" IS PLACE IN CELLS (B1:B40) If another "A" IS ENTERED BETWEEN (A1:A40)THEN Fig "2" IS PLACE IN CELLS (B1:B40)AND SO ON NUMBERING CELLS IN SEQUENTIAL ORDER 3,4,5. SO IF THERE ARE 5 "A",S IN ROW (A1:A40) ROW (B1:B40) WOULD HAVE THE NUMBERS 1,2,3,4,5. BUT NOW I WHANT A CHOICE OF LETTER'S I WANT BE ABLE TO USE A,B,C AND D IN ROW (A1:A40) EACH LETTER GIVING IT'S OWN SEPERATE COUNT AS WE GO DOWN THE ROW (A1:A40) SO IF I ENTER "A" THAT WILL HAVE THE NUMBER 1 IF I NOW ENTER "B" THATS THE FIRST "B" ENTERED SO IT WILL BE NUMBERD 1 ALSO IF I ENTER ANOTHER "B" THATS 2

ITEM A 1
ITEM B 1
ITEM B 2
ITEM A 2
ITEM C 1
ITEM D 1
ITEM A 3

6 replies

by tig2

Can we have another go at this? I couldn't tell what your existing formulae is not what you wish to get to.

Please turn off the "All Caps". It makes this even more difficult to read. I will return to see is you have additional information.

by charliespencer

Pretend the rows below are in a spreadsheet.

AABC ABBCC BCDDD AC
211 122 0113 103

Where the numbers in the second row represent the count of each character in the first row. He's looking for a formula to generate the second row based on what characters are entered in the first row. I'm sure it's going to involve Count and String functions.

What I really want to know is, "Why???"

Edited: I forgot HTML would remove the spaces I used to lay this out. Pretend each entry is in it's own cell, and that the cells in the second row line up under the first row.

by buzby

Work Duty's. A working shift will finish at a certain time of the day. If it finishes before 14:30 it'an "E" (EARLY) duty, up to 20:30 it's a "M" (Middle) duty, "L" for (Late)and lastly "S" (SPLIT)duty.

DUTY HOURS SHIFT NUMBER DAYS OPP

HAN01 7:30 E 1 MON - FRI
HAN02 6:20 E 2 SATURDAY
HAN03
HAN04
HAN05 7:00 M 1 MON - FRI
HAN06 5:10 M 2 SUNDAY
HAN07 7:40 L 1 SATURDAY
HAN08 8:20 S 1 MONDAY
Hope this helps...

by delbertpgh

It counts the number of cells whose contents match a string.

by buzby

function: =COUNTIF($B$2:B2,B2)
Works for me! Thanks DelbertPGH

This discussion is closed to new replies.