one more question regarding counting in different bases

youbet7469

New Member
Joined
Mar 20, 2002
Messages
12
Hello,
First want to thank all of you who worked on the counting in bases functions. Your assistance is greatly appreciated.

In our discussion it was deteremined that the correct way to count in bases is
For example base 5:
0-1-2-3-4-10-11-12-13-14-20-21-22-23-24-30

Is there a way to adjust the formula so that counting in base 5 would appear as I initially had thought it should appear:
1-2-3-4-5-11-12-13-14-15-21-22-23-24-25-31

Basically am looking to "bump" everything to the right one place and skip the "zeros"
Granted this isn't "textbook" but if someone thinks this can be done I'd greatly appreciate it.

Best Regards,
Greg
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
On 2002-04-17 15:33, youbet7469 wrote:
Hello,
First want to thank all of you who worked on the counting in bases functions. Your assistance is greatly appreciated.

In our discussion it was deteremined that the correct way to count in bases is
For example base 5:
0-1-2-3-4-10-11-12-13-14-20-21-22-23-24-30

Is there a way to adjust the formula so that counting in base 5 would appear as I initially had thought it should appear:
1-2-3-4-5-11-12-13-14-15-21-22-23-24-25-31

Basically am looking to "bump" everything to the right one place and skip the "zeros"
Granted this isn't "textbook" but if someone thinks this can be done I'd greatly appreciate it.

Best Regards,
Greg

Unless you are working with the bases with alpha characters, would adding one work? Find the base conversion with the UDF and add one to it.

Most important: Don't mess with Damon's function.

As an aside, why do you want to do this, anyway?

Bye,
Jay
 
Upvote 0
Hey Jay,

Thanks for the reply... I didn't realize earlier that you were the one who answered my other question as well.

I've tried adding one to a number of places in the formula you guys gave me along with adding one to each cell in excel and neither have provided me with satisfactory results.

You asked my why I'm looking to do this. I'm doing some research on Egyptian Counting and the below paragraph should give you an idea of why I'm looking to count in this way

"The Egyptians, though, had no concept for zero. The zero was invented independently both by the Indians (thanks to Ranjeev Ravi for pointing this out) and the Maya. The Indians used a space for zero, and the Maya used a symbol for zero in their calendars in the 3rd century AD. Eventually, the Indians came to use a dot for zero, which was picked up by the Arabs. Through the Arabs, the number zero reached European civilisation after 800 AD. The ancient Egyptians, as with the ancient Greeks and Romans, had no use for zero."

Counting in base three with no concept for zeros would go as follows:
1,2,3,11,12,13,21,22,23,31,32,33,111,112,113,121,122,123,131,132,133,211,212,213,221,222,223,231,232,233,311,312,313,321,322,323,331,332,333,1111 etc....

I think the difficulty in attempting to do this is going to be getting rid of the zeros.
Is there a way to do this? Let me know what you think

Thanks again for all your help!
Best Regards,
Greg
 
Upvote 0
Basically you want something that would act like a binary code, but instead of the binary being 1,0 you want it to be 1,2,3,4,5.

So it would look something like:
1,2,3,4,5,11,12,13,14,15,21,22,23,24,25,31,32,33,34,35,41,42,43,44,45,51,52,53,54,55,111,112,113,114,115,...

Is this what you are looking to try and do?
 
Upvote 0
Al, yes that is exactly what I am looking for. I'd definetly like to do it for all bases 3 thru 9 if we could go do even higher bases that would be great too.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,099
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top