ExcelNovice
Well-known Member
- Joined
- May 12, 2002
- Messages
- 583
All, I'm working on a large spreadsheet.The following cells starts out with zero:
HA125, HG125, HM125, HS125, HY125, IE125, IK125, IQ125, HA135, HG135, HM135, HS135, HY135, IE135, IK135, IQ135, HA145, HG145, HM145, HS145, HY145, IE145, IK145, IQ145, HA155, HG155, HM155, HS155, HY155, IE155, IK155, IQ155, HA165, HG165, HM165, HS165, HY165, IE165, IK165, IQ165, HA175, HG175, HM175, HS175, HY175, IE175, IK175, IQ175, HA185, HG185, HM185, HS185, HY185, IE185, IK185, IQ185, HA195, HG195, HM195, HS195, HY195, IE195, IK195, IQ195
The user will then enter the #6 data in each cell only once, but will enter the number 6 randomly. For instance, the first 6 may be entered in cell IK175, the second in cell HA125 and so on.
Question, is there a way to determine the order in which each 6 was entered? Which one was first, second, third and so on?
Thanks for your help.
HA125, HG125, HM125, HS125, HY125, IE125, IK125, IQ125, HA135, HG135, HM135, HS135, HY135, IE135, IK135, IQ135, HA145, HG145, HM145, HS145, HY145, IE145, IK145, IQ145, HA155, HG155, HM155, HS155, HY155, IE155, IK155, IQ155, HA165, HG165, HM165, HS165, HY165, IE165, IK165, IQ165, HA175, HG175, HM175, HS175, HY175, IE175, IK175, IQ175, HA185, HG185, HM185, HS185, HY185, IE185, IK185, IQ185, HA195, HG195, HM195, HS195, HY195, IE195, IK195, IQ195
The user will then enter the #6 data in each cell only once, but will enter the number 6 randomly. For instance, the first 6 may be entered in cell IK175, the second in cell HA125 and so on.
Question, is there a way to determine the order in which each 6 was entered? Which one was first, second, third and so on?
Thanks for your help.