I have an excel sheet with column A as ID. For a particular ID say 1, there may be a number of probabilities shown in column B. I need value 1 for the greater probability for the same ID and 0 for the rest ( shown as result in column C). A sample is shown in the attached excel sheet. please help me with this......
In C2 use this array formula
=IF(B2=MAX(IF($A$2:$A$19=A2,$B$2:$B$19)),1,0)
Confirm woith Ctrl+Shift+Enter and not jus Enter
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks