Excel formula to find position of the contents of a cell within a column.

Posts: n/a

Someone gave me the answer - case closed !

a =COUNTIF(A$1:A1,A1) Result = 1
b =COUNTIF(A$1:A2,A2) Result = 1
c =COUNTIF(A$1:A3,A3) Result = 1
a =COUNTIF(A$1:A4,A4) Result = 2
b =COUNTIF(A$1:A5,A5) Result = 2
b =COUNTIF(A$1:A6,A6) Result = 3
b =COUNTIF(A$1:A7,A7) Result = 4
a =COUNTIF(A$1:A8,A8) Result = 3
a =COUNTIF(A$1:A9,A9) Result = 4
c =COUNTIF(A$1:A10,A10) Result = 2

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can i get an If formula in excel to edit another cell?	Jimmy Hoffa	Excel Worksheet Functions	2	August 16th 05 05:53 PM
Why does Excel show a formula in ONE cell ?	edpaul	Excel Discussion (Misc queries)	1	August 12th 05 07:29 PM
Formula Arrays VERY SLOW in Excel 2002	Patrick	Excel Worksheet Functions	2	January 27th 05 12:59 AM
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't	Damaeus	Excel Worksheet Functions	12	January 23rd 05 04:52 PM
How do I view the actual numeric value of a formula in Excel 2002.	Excel Function Help	Excel Worksheet Functions	0	January 13th 05 10:07 PM

All times are GMT +1. The time now is 05:53 AM.

Menu

About Us