ryan_law2000
Well-known Member
- Joined
- Oct 2, 2007
- Messages
- 738
Everyone I need a formula to capture the follow
Sheet1 = data entry
Sheet2 = table to display data
on Sheet2 A1 = If (Column D:D on Sheet 1) = a number and value in Column E (on the same row) has any text then display value from column E
on Sheet2 A2 = Display the next value after the row above: If (Column D on Sheet 1) = a number and value in Column E has text then display value from column E
any ideas how to accomplish this?
thanks
Sheet1 = data entry
Sheet2 = table to display data
on Sheet2 A1 = If (Column D:D on Sheet 1) = a number and value in Column E (on the same row) has any text then display value from column E
on Sheet2 A2 = Display the next value after the row above: If (Column D on Sheet 1) = a number and value in Column E has text then display value from column E
any ideas how to accomplish this?
thanks