[Solved] Compare 3 columns values

Discuss the spreadsheet application

[Solved] Compare 3 columns values

Postby campanico » Mon Apr 08, 2019 4:13 pm

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 12 times
3eows.jpg
Last edited by campanico on Tue Apr 09, 2019 5:16 pm, edited 1 time in total.
OpenOffice 3.1 on Windows 8
campanico
 
Posts: 50
Joined: Wed Nov 06, 2013 4:48 pm

Re: Compare 3 rows values

Postby MrProgrammer » Mon Apr 08, 2019 10:17 pm

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 6 times
E is a column, not a row. Based on your small example:
201904081218.ods
Solution
(15.23 KiB) Downloaded 10 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.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3815
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Compare 3 rows values

Postby campanico » Tue Apr 09, 2019 5:15 pm

Thank you very much, it´s a pretty clever solution that works all the way
OpenOffice 3.1 on Windows 8
campanico
 
Posts: 50
Joined: Wed Nov 06, 2013 4:48 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests