[Solved] Compare 3 columns values

Discuss the spreadsheet application
Post Reply
campanico
Posts: 50
Joined: Wed Nov 06, 2013 4:48 pm
Location: X: viagrasansordonnancefr.com/

[Solved] Compare 3 columns values

Post by campanico »

Hello I need to compare values from 3 rows and then valitade if conditions are right or wrong.
TYVM for the atention.
Attachments
compare TL_1p_2p.ods
(9.73 KiB) Downloaded 95 times
3eows.jpg
Last edited by campanico on Tue Apr 09, 2019 5:16 pm, edited 1 time in total.
User avatar
MrProgrammer
Moderator
Posts: 4883
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Compare 3 rows values

Post by MrProgrammer »

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?
compare%20TL_1p_2p.ods
Original data, to prevent OP from deleting it like topic 88129
(9.73 KiB) Downloaded 57 times
E is a column, not a row. Based on your small example:
201904081218.ods
Solution
(15.23 KiB) Downloaded 73 times
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.

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).
campanico
Posts: 50
Joined: Wed Nov 06, 2013 4:48 pm
Location: X: viagrasansordonnancefr.com/

Re: Compare 3 rows values

Post by campanico »

Thank you very much, it´s a pretty clever solution that works all the way
Post Reply