ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help to write a formaula (https://www.excelbanter.com/excel-worksheet-functions/109185-help-write-formaula.html)

Dinesh

Help to write a formaula
 
Row 2 - Col A thru D has peoples name A, B, C, D
Row 2 - Col E thru H has same peoples name A, B, C, D
Row 3 - Col A has $10 (person A)
Row 3 - Col F has $10 (person B)
Row 3 - Col I should have formula (I am thinking IF formula ?) where the
result should returns "From A to B". meaning person A has $ 10 which needs to
be transfer to person "B".

Row 4 Col B (person B) and Col E (person A) has $11
Row 4 Col I should return the result "From B to A".


Biff

Help to write a formaula
 
As long as each group of columns will only have one number per group:

Enter this formula in I3:

=IF(COUNT(A3:H3)<2,"","From "&LOOKUP(10^99,A3:D3,A$2:D$2)&" to
"&LOOKUP(10^99,E3:H3,E$2:H$2))

Copy down as needed.

Biff

"Dinesh" wrote in message
...
Row 2 - Col A thru D has peoples name A, B, C, D
Row 2 - Col E thru H has same peoples name A, B, C, D
Row 3 - Col A has $10 (person A)
Row 3 - Col F has $10 (person B)
Row 3 - Col I should have formula (I am thinking IF formula ?) where the
result should returns "From A to B". meaning person A has $ 10 which needs
to
be transfer to person "B".

Row 4 Col B (person B) and Col E (person A) has $11
Row 4 Col I should return the result "From B to A".





All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com