• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Doubling Increases Value - How do I equate that?

E

Edward Wilke

New Member
Ok, so here's what I have so far:

The user inputs up to twenty values.
If the numbers are all the same (quite common) it counts how many of that number


Here's what I need:

If there is only one number, the result is that number. But, each time it doubles, (1:2:4:8:etc) the result is +2 from the previous.

Ex:

4 = 4
4,4 = 6
4,4,4,4 = 8
4,4,4,4,4,4,4,4 = 10



I also need to check if the values are all the same. If they are not, there is a different algorithm needed to calculate the result.
 
Hi Edward ,

I think the problem definition is not sufficiently detailed.

You say the user inputs up to 20 values ; I assume these are 20 values in the same cell , separated by commas.

If the input consists of only 1 number , then it is that number itself ; if not , then it depends on what occurred earlier ; does this mean that the data entry will be in successive cells down a column ?

Suppose we assume data entry starts from A2 , and goes down column A ; suppose the data entry has been as follows :

2,2,2,2,2,2
1,2,2,3,2,2
2
3,3,3
2
2,2,2,2,2,2,2,2,2
1,1,1,1
1,1,1
3,3,3,3,3
3,3,3,3,3,3,3,3,3,3

For the above data entry , what would be the result in each row ?

Narayan
 
Thank you for the response, but actually, I figured it out.

I actually have it set up for each value in a separate cell. And, as for having multiple values in a given series, (1,1,2,3; 1,2,3,4; etc) the formulae is completely different, but I figured that one out too.

I do, however, now have a different, probably easier problem. I just don't know the syntax/language for excel enough.


I need to draw specific data from a large table and then add up the data.

Ex:

Data Table

-- 1y--2y--3y--4y--5y
1x- A -- B -- C -- D -- E
2x- F -- G -- H -- I -- J
3x- K -- L -- M -- N --O
4x- P -- Q -- R -- S -- T
5x- U -- V -- W -- X -- Y

Given Info: 1x,3y
Result: "C"

Given Info: 2x,5y
Result: "J"


I apologize if this isn't written understandably.
 
@Edward Wilke

For your above problem use Index and Match

=INDEX(B2:F6,MATCH("1x",B1:F1,0),MATCH("3y",A2:A6,0))

B2:B6 is your data A,B,C..... and B1:F1 is your column header and A2:A6 is your row headers.

Just advise if any issue.

Regards,
 
You must log in or register to reply here.
Back
Top