carmatic Posted July 29, 2016 Share Posted July 29, 2016 so let's say I have a spreadsheet with 3 columns I would like to find the rows in which the value in the second column is larger than the value in the 3rd column, and I want to know all the values in the first column of these rows. How do I do that? Link to comment Share on other sites More sharing options...
0 Daedroth Posted July 29, 2016 Share Posted July 29, 2016 I'm no excel wizard, but I'm wondering if conditional formatting may be the solution. I'll try and look into that and see if I can figure something out. Link to comment Share on other sites More sharing options...
0 carmatic Posted July 29, 2016 Author Share Posted July 29, 2016 2 hours ago, Daedroth said: I'm no excel wizard, but I'm wondering if conditional formatting may be the solution. I'll try and look into that and see if I can figure something out. Thank you, I am using google sheets and I found this https://support.google.com/docs/answer/78413?co=GENIE.Platform%3DDesktop&hl=en Link to comment Share on other sites More sharing options...
Question
carmatic
so let's say I have a spreadsheet with 3 columns
I would like to find the rows in which the value in the second column is larger than the value in the 3rd column, and I want to know all the values in the first column of these rows.
How do I do that?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts