I have a large spreadsheet of a 10-min bird survey data, where each survey minute has a column. Each row is a species observation. Right now, for some species, there are Xs under each minute column where a species was detected. I would like to change the first X in each row to a 1, and all subsequent Xs in that row to 0s. is there an IF function I could use to do this? Thanks! example.xlsx
Try this one in C3 and pull formula to the right
=IF(AND(C2="X",COUNTIF($C2:C2,"X")=1),1,0)
Last edited by AlKey; 01-16-2015 at 11:32 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
Find the attached with a macro to do what I think you want. The code looks like this:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
The macro worked very well; thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks