I have a DB of auction items sold, how can I create receipt?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nwtf_vol - 21 Jan 2008 14:23 GMT

I have a list of auction items, and as they are sold I will be filling in the
customer number next to the corresponding item (column headings are cust# and
item description). I want to be able to create a receipt from this data. I
have the receipt formatted and created. However, I am having trouble when a
user has multiple purchases because when I look up the data, I always only
find the first entry for a specific customer in the list. I think I need to
index the value some how, but I am not sure. Can someone help me out on the
formula I will need to use to return the next value in the table? Thank you,
I really appreciate the help.

Reply to this Message

Gaurav - 21 Jan 2008 15:28 GMT

Suppose your Customer number is in B1, you want the purchases in B3. In
Sheet1 you have customer numbers in Column A and Items Purchased in Column
D.

Enter this array formula in B3 and drag down till the time you get blank.

=IF(ROWS(B$3:B3)<=COUNTIF('Sheet1!D$1:D$100,B$1),INDEX('Sheet1'!A$1:A$100,SMALL(IF('Sheet1'!D$1:D$100=B$1,ROW('Sheet1'!A$1:A$100)-MIN(ROW('Sheet1'!A$1:A$100))+1),ROWS(B$3:B3))),"")

Press CTRL+SHIFT+ENTER not just ENTER.

Thanks

>I have a list of auction items, and as they are sold I will be filling in
>the
[quoted text clipped - 12 lines]
> you,
> I really appreciate the help.

Reply to this Message

nwtf_vol - 21 Jan 2008 19:09 GMT

I tried using this formula and it didn't seem to work. I am probably doing
something wrong. On my receipt, the customer number is in cell E7, and I
want the purchases to start in row 17 and go down (b17 is the item#, c17 is
the item description, and e is the item price). The other sheet contains my
auction items with the cust# in column a, the item# in column b, and the
description in column c. I thought I adjusted the formula properly, but it
didn't return anything. Can you help me one more time? Thank you!!!

> Suppose your Customer number is in B1, you want the purchases in B3. In
> Sheet1 you have customer numbers in Column A and Items Purchased in Column
[quoted text clipped - 24 lines]
> > you,
> > I really appreciate the help.

Reply to this Message