sum cells to reach a specific value and return corresponding value

B

belladelly

Hi,

I have a csv table that has data for delivery drops. If there is more than
one item to be delivered on one drop the there is a total in one row and then
the rows below have the number of items and a product code.

i.e.
5 = Total Items
4 = 4 units product 'a'
1 = 1 unit of product 'b'

the formula needs to recognise that if there are a total of 5 items it will
count the number of rows below to tally a total of 5 and then merge the
product codes and descriptions in one cell using the CONCATENATE FORMULA -

is there an 'if' or a 'sum' function that can count values in the cells and
do this?

Thanks - CL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dumb question alert! What program to use? 0
Drop down list control value in vba 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Return corresponding information with minimum value 2
use month in cell date to sum all relevant cells 2
Look up one value and return multiple corresponding values 2
Looking formula that SUM values with specific value in neighboring colum 2
Arriving at totals 2

Top