Hello I need to compare values from 3 rows and then valitade if conditions are right or wrong.
TYVM for the atention.
[Solved] Compare 3 columns values
[Solved] Compare 3 columns values
- Attachments
-
- compare TL_1p_2p.ods
- (9.73 KiB) Downloaded 95 times
Last edited by campanico on Tue Apr 09, 2019 5:16 pm, edited 1 time in total.
- MrProgrammer
- Moderator
- Posts: 4883
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Compare 3 rows values
E is a column, not a row. Based on your small example: I ignored your data consistency problems in column D. Open a separate topic if you need assistance with that. Use Data → Validity and/or Format → Conditional Formatting.campanico wrote:Hello I need to compare values from 3 rows and then valitade if conditions are right or wrong. What would be the way for checking this and display the result at Row E?
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: Compare 3 rows values
Thank you very much, it´s a pretty clever solution that works all the way