Free AI bot that generates the Excel formula for any problem

Topic

New Reply

https://excelformulabot.com/

A project to help everyone learn Excel formulas.

Reply | Quote

Replies

Wow.

Reply | Quote

I need a formula that compares columns A-G on Sheet1 to Sheet3. If any of the text on Sheet3 matches column E on Sheet1, print all data on Sheet2

Reply | Quote

=IF(AND(B3=B4,B4=B5,B5=B6,B6<>B7),IF(AND(B3=B4,B4=B5,B5<>B6),IF(AND(B3=B4,B4<>B5),C3+C4,C3+C4+C5),C3+C4+C5+C6),””)

Reply | Quote