d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Any Excel Experts Here? > Paying Fg
Add Reply New Topic New Poll
Member
Posts: 2,726
Joined: Jul 1 2017
Gold: 500.00
May 13 2019 04:04pm
I have a spread sheet with two columns with 6000+ rows and I want them in an order that shows column 1's number is less than column 2's number, any way I can do this via excel instead of manually going through 6000+ checking if column 1 is lower than column 2.
Thanks lmk
Member
Posts: 4,028
Joined: Dec 4 2018
Gold: 56,369.16
May 14 2019 12:08pm
Can't you just extend the sheet with another column, where the value in Col C for row 1 (C1) = A1 < B1, and then extend that to all rows, and then apply sorting by true?
Member
Posts: 64,656
Joined: Oct 25 2006
Gold: 260.11
May 14 2019 09:01pm
You're an md student and cant Google excel commands?
Member
Posts: 3,054
Joined: Mar 30 2003
Gold: 5,498.00
May 21 2019 06:01pm
The way you'd do it is to go to column c and add the formula =a1<b1 then double click the bottom right corner of the cell (to expand the formula all the way down...) then if a1 is less than b1 it'll say TRUE.. else FALSE..
Member
Posts: 9,432
Joined: Aug 13 2007
Gold: 20.00
May 23 2019 06:51pm
Quote (Thor123422 @ May 14 2019 10:01pm)
You're an md student and cant Google excel commands?


:rofl:
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll