Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2021, 10:50 AM
allex011 allex011 is offline Repeat values in row Windows 7 32bit Repeat values in row Office 2007
Advanced Beginner
Repeat values in row
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default Repeat values in row

I need help solving the problem. I need to put on SharePoint an excel file that would be populated with data, but if some data is repeated in three cells within in single row a message should appear (like data validation error alert)informing that that values already exist.Is it possible solve this only with formulas?


Thanks in advanced
Attached Files
File Type: xlsx Problem.xlsx (37.8 KB, 6 views)
Reply With Quote
  #2  
Old 07-01-2021, 12:58 PM
Purfleet Purfleet is offline Repeat values in row Windows 10 Repeat values in row Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

have they all got to be in the same row to match? i.e your example row 7 ,matches row 2. or can the 10 be in row 2, the 200 in row 5 and the 1000 in row 6?
Reply With Quote
  #3  
Old 07-01-2021, 01:06 PM
allex011 allex011 is offline Repeat values in row Windows 7 32bit Repeat values in row Office 2007
Advanced Beginner
Repeat values in row
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default

Yes, they got to be in the same row, but it doesn't matter in what row is it, all rows need to be unique.
Reply With Quote
  #4  
Old 07-01-2021, 01:24 PM
Purfleet Purfleet is offline Repeat values in row Windows 10 Repeat values in row Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

have a look at the attached, i have added a formula in column D that is true if all 3 match. I have also added the formula into the Conditional formatting so it highlights.

please note i have changed your numbers around
Attached Files
File Type: xlsx Problem_AR12.xlsx (11.9 KB, 12 views)
Reply With Quote
  #5  
Old 07-01-2021, 02:16 PM
allex011 allex011 is offline Repeat values in row Windows 7 32bit Repeat values in row Office 2007
Advanced Beginner
Repeat values in row
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default

Thank you very much.You save me.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 9 07-27-2018 02:06 AM
Repeat values in row Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 6 06-09-2018 10:51 PM
Repeat values in row repeat if paltser Excel 1 12-01-2015 09:32 AM
Display multiple values as new values based on selection from template. MvdB Excel 2 09-29-2015 08:51 PM
Repeat formula 5 times and repeat? Jenny345 Excel 4 06-14-2013 04:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft