X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Show Result On Both Row If Same Serial Number, Office 2013    
post Sep 27 2019, 02:54 AM

Posts: 508
Joined: 11-July 09

Hi all,

I would like to know, how can I make it work when column A has the same Serial Number, then substration of days and the result will Show on both row…

I have Tried



Thanks for any help.

Attached File(s)
Attached File  UtterAccess_Picture.png ( 12.97K )Number of downloads: 5
Attached File  AccessUtter.zip ( 6.88K )Number of downloads: 3
Go to the top of the page
post Sep 27 2019, 07:25 AM

Posts: 69
Joined: 18-August 16
From: Bristol, UK

If I have understood your requirement correctly then in cell F2:


Then drag down to fill the series.
Go to the top of the page
post Sep 27 2019, 09:14 AM

Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


Never stop learning, because life never stops teaching.
Go to the top of the page
post Sep 30 2019, 02:13 AM

Posts: 508
Joined: 11-July 09

Hi Vince,

I was out on the weekend. Could not thanks you before. It works wonderfully. thumbup.gif

Thanks again.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    13th November 2019 - 06:12 PM