Thread: [Solved] Help with a formula
View Single Post
 
Old 07-12-2020, 09:53 PM
Purfleet Purfleet is offline Windows 10 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

=IF(COUNTIFS($B$2:B2,B2)=1,".",A2-A1) should do the trick
Attached Files
File Type: xlsx Examplemsof_PURFLEET.xlsx (10.2 KB, 8 views)
Reply With Quote