ST Alpha - "here's what i do, but it's not very efficient" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 169

In response to "Excel Question Inside" by Dano

here's what i do, but it's not very efficient

Posted by prayformojo (aka mayhem) Feb 19 '09, 08:04

write a function in a column next to the email column
=(if b2=b1,'Yes','No')

then save the worksheet as text - not as an excel document

then reopen the text file in excel.

then sort by the yes/no field.

you have to save it as non-excel to get rid of the forumula

Responses:

Instead of 'Yes','No' can I do 'Monkey','Robot'? -- nm - Dano Feb 19, 08:07
If you copy the column, then Paste Special and choose Values, it overwrites the formula. -- nm - JaxSean Feb 19, 08:06 1
- really? cool, i'll remember this! -- nm - prayformojo Feb 19, 08:08

Post a message top

here's what i do, but it's not very efficient

Replies are disabled on threads older than 7 days.