☰
d2jsp
Rules
Help
Forum Gold FAQ
Live Streams
Photo Gallery
Hourly Raffle
Ladder Slasher
Log In
Register
Log In
Register
Account Recovery
Resend Validation Email
d2jsp Forums
>
Off-Topic
>
Computers & IT
>
Programming & Development
> Any Excel Experts Here? > Paying Fg
Add Reply
New Topic
New Poll
Views: 391
Replies: 4
Track Topic
Physician
Member
Posts: 2,726
Joined: Jul 1 2017
Gold
:
500.00
#1
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
Touta
Member
Posts: 4,028
Joined: Dec 4 2018
Gold
:
56,369.16
#2
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?
Thor123422
Member
Posts: 64,656
Joined: Oct 25 2006
Gold
:
260.11
#3
May 14 2019 09:01pm
You're an md student and cant Google excel commands?
squirrel
Member
Posts: 3,054
Joined: Mar 30 2003
Gold
:
5,498.00
#4
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..
EViLDeeDz
Member
Posts: 9,432
Joined: Aug 13 2007
Gold
:
20.00
#5
May 23 2019 06:51pm
Quote (Thor123422 @ May 14 2019 10:01pm)
You're an md student and cant Google excel commands?
Go Back To
Programming & Development
Topic List
Add Reply
New Topic
New Poll
© 2003-2024 d2jsp
Contact