Hi there,

This is my first post. Hope I am in the correct place.

I have a worksheet of user data. I have username and deposit fields. I
made 2 new fields called "Deposit 2", "Deposit 3".

So this is basically an output of all my users deposits. So if someone
deposited 3 times, it will say:

Rhythm 50.00
Rhythm 30.00
Rhythm 100.00

I want to do an IF statement saying: "If Rhythm appears more than once,
move his 2nd deposit value (50.00) into Deposit 2 field (in the Rhythm
row!) and move 3rd deposit into Deposit 3 (again in the Rhythm row). So
the end result is that some people will have only Deposit 1 populated,
while others will have all 3.

Some users have 1 deposit, some have 3. So....I'm a bit of a n00b and
if anyone can help that would appreciated.

Hope I explained myself properly. Feel free to email me directly.

Regards,

Rhythm


--
Rhythm
------------------------------------------------------------------------
Rhythm's Profile: http://www.excelforum.com/member.php...o&userid=28705
View this thread: http://www.excelforum.com/showthread...hreadid=483877