re-order a list based on different citeria

[petethecat]

A little while ago i was give this formula to help me re-order a list based on the fact that it is mixed letters & numbers. IE if a letter "R" is in the list then it becomes 1, if in the same list a 1 appears this becomes a 2 & so on

=IF(A1="R",1,IF(A1=0,MAX(A$1:A$11)+COUNTIF(A$1:A1,0)+1,A1+1))

What i want to do is change this formula so that it gives me a list, in ascending order if there is NO LETTER "R" (or indeed any letter).

So if there is an "R" this would be the first & any numbers would be plus one - so 1 would be 2, 2 would be 3 etc.

If there are no letters then it reverts to the number sequence. IE 1 is 1, 2 is 2 etc.

Any help is greatly appreciated!

 

[jtakw]

Hi,

Solution provided in your original thread here:

https://www.mrexcel.com/forum/excel...se-if-statements-post5277918.html#post5277918

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).