UtterAccess.com
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    
 
   
kenwood1
post Sep 27 2019, 02:54 AM
Post#1



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

=if(A2=A3;D3-D2;"")

=If(OR(A1=A2;A2=A3;D3-D2);F3;"")


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
 
Vince
post Sep 27 2019, 07:25 AM
Post#2



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


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

=IF(A2=A3,D3-D2,IF(A2<>A3,F1))

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



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



=IF(A2=A3,F3,F2)

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



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