Beyond.ca

Registration is free! Car Forums - Member Rides Car Forums - Find other members Car Forums - Calendar Car Forums - Frequently Asked Questions Forum Rules and Regulations Car Forums - Search Logout
Beyond.ca - Car Forums : Powered by vBulletin version 2.3.9 Beyond.ca - Car Forums > Lounge > Computers, Consoles, and other Electronics > Looking for some Excel help


Author
Thread
outsider
Newbie

Location: Calgary
What I drive:
Posts/Day: 0.01
Trader Rating: (8)
User Rating: 100%


Looking for some Excel help quote:

I'm having a difficult day already and I can't seem to think of a formula for this. In one column I have a set of numbers in one column (far left) and in the other dates. What I need is to create a formula to have a number sequence of 1,2,3 but changing with each new number in the far left column:
0000010910 05/04/2014 5/31/2015
0000010910 05/05/2013 5/3/2014
0000011270 05/04/2014 5/31/2015
0000011270 07/15/2013 5/3/2014
0000011280 05/04/2014 5/31/2015
0000011280 07/15/2013 5/3/2014
0000011290 05/04/2014 5/31/2015
0000011290 07/15/2013 5/3/2014
0000011300 05/04/2014 5/31/2015
0000011300 07/15/2013 5/3/2014
0000011310 05/04/2014 5/31/2015
0000011310 07/15/2013 5/3/2014
0000011320 05/04/2014 5/31/2015
0000011320 07/15/2013 5/3/2014
0000011330 05/04/2014 5/31/2015
0000011330 07/15/2013 5/3/2014
0000011340 05/04/2014 5/31/2015
0000011340 07/15/2013 5/3/2014
0000011350 05/04/2014 5/31/2015
0000011350 07/15/2013 5/3/2014
0000011360 05/04/2014 5/31/2015
0000011360 07/15/2013 5/3/2014
0000011370 05/04/2014 5/31/2015
0000011370 07/15/2013 5/3/2014
0000011380 05/04/2014 5/31/2015
0000011380 07/15/2013 5/3/2014
0000011390 05/04/2014 5/31/2015
0000011390 07/15/2013 5/3/2014
0000011400 05/04/2014 5/31/2015


If you can help that would be great. Thanks

Report this post | IP: Logged

Old Post 03-27-2017 04:33 PM
outsider is offline Click Here to See the Profile for outsider Click here to Send outsider a Private Message Find more posts by outsider Edit/Delete Message Reply w/Quote
 
Thaco
sucks off little boys (ya, don't fuck with rage2 bitch!!!)

Location: Calgary
What I drive: Rage2
Posts/Day: 0.72
Trader Rating: (29)
User Rating: 90%


quote:

you just want a count of unique numbers in the far left column?

=SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))

__________________
User title molested by Rage2.

Report this post | IP: Logged

Old Post 03-27-2017 04:36 PM
Thaco is offline Click Here to See the Profile for Thaco Click here to Send Thaco a Private Message Find more posts by Thaco Edit/Delete Message Reply w/Quote
outsider
Newbie

Location: Calgary
What I drive:
Posts/Day: 0.01
Trader Rating: (8)
User Rating: 100%


quote:

Thaco I must be doing something incorrect. I have the #'s in column C and the dates in D &E. I'm trying to replace A with C but i'm getting an error.

I tried =IF(C2<>C1,1,F1+1) and get the number 1 but when I click and drag down it only stays as 1

Report this post | IP: Logged

Old Post 03-27-2017 04:48 PM
outsider is offline Click Here to See the Profile for outsider Click here to Send outsider a Private Message Find more posts by outsider Edit/Delete Message Reply w/Quote
tobslau
Newbie

Location: Calgary
What I drive: Jetta TDI
Posts/Day: 0.02
Trader Rating: (1)
User Rating: 100%


quote:

formula in Column B - assuming the length of the left text doesn't change (10 characters).

Else, text to columns with spaces first to isolate it.

=IF(LEFT(A3,10)=LEFT(A2,10),B2,B2+1)

attached an excel file.

Column A Column B
Title 0
0000010910 05/04/2014 5/31/2015 1
0000010910 05/05/2013 5/3/2014 1
0000011270 05/04/2014 5/31/2015 2
0000011270 07/15/2013 5/3/2014 2
0000011280 05/04/2014 5/31/2015 3
0000011280 07/15/2013 5/3/2014 3
0000011290 05/04/2014 5/31/2015 4
0000011290 07/15/2013 5/3/2014 4
0000011300 05/04/2014 5/31/2015 5
0000011300 07/15/2013 5/3/2014 5
0000011310 05/04/2014 5/31/2015 6
0000011310 07/15/2013 5/3/2014 6
0000011320 05/04/2014 5/31/2015 7
0000011320 07/15/2013 5/3/2014 7
0000011330 05/04/2014 5/31/2015 8
0000011330 07/15/2013 5/3/2014 8
0000011340 05/04/2014 5/31/2015 9
0000011340 07/15/2013 5/3/2014 9
0000011350 05/04/2014 5/31/2015 10
0000011350 07/15/2013 5/3/2014 10
0000011360 05/04/2014 5/31/2015 11
0000011360 07/15/2013 5/3/2014 11
0000011370 05/04/2014 5/31/2015 12
0000011370 07/15/2013 5/3/2014 12
0000011380 05/04/2014 5/31/2015 13
0000011380 07/15/2013 5/3/2014 13
0000011390 05/04/2014 5/31/2015 14
0000011390 07/15/2013 5/3/2014 14
0000011400 05/04/2014 5/31/2015 15

Attachment: capture.jpg

Report this post | IP: Logged

Old Post 03-27-2017 04:55 PM
tobslau is offline Click Here to See the Profile for tobslau Click here to Send tobslau a Private Message Find more posts by tobslau Edit/Delete Message Reply w/Quote
outsider
Newbie

Location: Calgary
What I drive:
Posts/Day: 0.01
Trader Rating: (8)
User Rating: 100%


quote:

Thanks Thaco & tobslau. I was able to get it to work.

Report this post | IP: Logged

Old Post 03-27-2017 05:44 PM
outsider is offline Click Here to See the Profile for outsider Click here to Send outsider a Private Message Find more posts by outsider Edit/Delete Message Reply w/Quote
Thaco
sucks off little boys (ya, don't fuck with rage2 bitch!!!)

Location: Calgary
What I drive: Rage2
Posts/Day: 0.72
Trader Rating: (29)
User Rating: 90%


quote:

Originally posted by outsider
Thaco I must be doing something incorrect. I have the #'s in column C and the dates in D &E. I'm trying to replace A with C but i'm getting an error.

I tried =IF(C2&lt;&gt;C1,1,F1+1) and get the number 1 but when I click and drag down it only stays as 1

it should work if you change "A2:A10" to your range, in both places, and the cells are formatted as numbers, if its formatted text it wont work.

__________________
User title molested by Rage2.

Report this post | IP: Logged

Old Post 03-27-2017 05:46 PM
Thaco is offline Click Here to See the Profile for Thaco Click here to Send Thaco a Private Message Find more posts by Thaco Edit/Delete Message Reply w/Quote
The time now is 07:45 PM (GMT) Post New Thread   
  Last Thread   Next Thread
Beyond.ca - Car Forums : Powered by vBulletin version 2.3.9 Beyond.ca - Car Forums > Lounge > Computers, Consoles, and other Electronics > Looking for some Excel help



Show Printable Version | Email this Page | Subscribe to this Thread


Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is ON
 

Google
 
Web beyond.ca

Terms of Use - Contact Us - Advertising Info - Archives - Car Blog

Powered by: vBulletin Version 2.3.9
Copyright ©2009 Jelsoft Enterprises Limited.

Bringing Car Enthusiasts together in discussion on our car forums

Page Statistics : Page generated in 1.05227494 seconds (4.12% PHP - 95.88% MySQL) with 33 queries.