Excel function

Save Share

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

29 November 2012 The following is the situation

1. I have in one coloumn 50 numbers
2. In the next column, there are 10 numbers, and one of such number is the sum total of 15 numbers of the first column.

My Requirement:

Whether I can find out which are the 10 numbers of first coloumn which forms the one consolidated figure of first coloumn

@VaibhavJ

@VaibhavJ (Expert)

29 November 2012 Hey Hi

How do you want to find it?

By going to the formula bt pressing F2 you can see the range summed on.

You can go to that cell which has sum of 10 nos. then just press Ctr + [ keys.

All summed cell wil get selected & you can change colour of selected cell.

If you have any other form of Imagination to get cell summed for each result, i can help you out.

Thanks//Vaibhav
Revert for more clarity.
Use thank button to convey your appreciation.

Message likes : 1 times

Querist : Anonymous

Querist : Anonymous (Querist)

29 November 2012 Thanks for your reply

But my problem is there is no formula visible as the data is copied from somewhere else using paste only values

Hope you can clarify the same

@VaibhavJ

@VaibhavJ (Expert)

29 November 2012 Hi

Then there is no possibility of finding exact 10 cells because there culd be many permutations & combinations.

Or else share me data will try to find out.

ca @ vabs.in

Thanks//vaibhav

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now