Auto Populate Multiple Adjacent Cells

[MrDB4Excel]

Some of the columns have me stumped. As you can see by the ISBLANK, ISERROR & other functions in columns A, I, J, K, L, M, N, O, & P that if a result is null then the cell is blank. I can’t seem to get these same functions to work as needed in columns B, C, D, E, F, G, & H.
Any help will be much appreciated. You will notice I have 2 entries regarding the Xl2bb that represent sheets Outlook Results and OutlookSortByName.

Conversations with Roger Caymin-2021.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3	Received Date Gleaned From Get Outlook Metadata.xlsm	Received Date Formulas	Received Time Formulas	Received Time In Formula	Received Time: Pasted Values From Column "D"	minute	Minute	Second	Sender	Subject	Doc #	Sender	Date to apply to From dodge or To dodge date column	Sender
4	10/11/2021 10:45:30	Mon 11/Oct/2021	10:45:30	10:45	10:45	10	45		dodge	Re: FW: Premium TRUE 1425: License to Kill	959 >	dodge	Mon 11/Oct/2021	dodge	959 >	1
5	10/11/2021 10:47:26	Mon 11/Oct/2021	10:47:26	10:47	10:47	10	47		dodge	Re: 12th Grade High School & This and that	960 >	dodge	Mon 11/Oct/2021	dodge	960 >	2
6	10/11/2021 12:12:08	Mon 11/Oct/2021	12:12:08	12:12	12:12	12	12		dodge	Re: Pineapples	962 >	dodge	Mon 11/Oct/2021	dodge	962 >	3
7	10/11/2021 13:23:11	Mon 11/Oct/2021	13:23:11	13:23	13:23	13	23		dodge	posting	964 >	dodge	Mon 11/Oct/2021	dodge	964 >	4
8	10/11/2021 09:31:02	Mon 11/Oct/2021	09:31:02	09:31	09:31	09	31		Codger	12th Grade High School & This and that	957 >	Codger	Mon 11/Oct/2021	Codger	957 >	5
9	10/11/2021 09:49:02	Mon 11/Oct/2021	09:49:02	09:49	09:49	09	49		Codger	FW: Premium TRUE 1425: License to Kill	958 >	Codger	Mon 11/Oct/2021	Codger	958 >	6
10	10/11/2021 11:08:11	Mon 11/Oct/2021	11:08:11	11:08	11:08	11	08		Codger	Pineapples	961 >	Codger	Mon 11/Oct/2021	Codger	961 >	7
11	10/11/2021 12:31:05	Mon 11/Oct/2021	12:31:05	12:31	12:31	12	31		Codger	Beach Boys	963 >	Codger	Mon 11/Oct/2021	Codger	963 >	8
12		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
13		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
14		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
15		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
16		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
17		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
18		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
19		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
20		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
21		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
22		#VALUE!	#VALUE!	#VALUE!	#VALUE!	######	######	######
Outlook Results

Cell Formulas
Range	Formula
A4:A22	A4	=IF(ISBLANK(OutlookSortByName!$A2)," ",(OutlookSortByName!$A2))
B4:B22	B4	=IF(A4="","",INT(A4))
C4:C22	C4	=IF(A4="","",A4 - INT(A4))
D4:D22	D4	=IF(C4="","",MROUND(C4,"0:1"))
E4:E22	E4	=D4
F4:F22	F4	=IF(HOUR($E4)=0,"",(HOUR($E4)))
G4:G22	G4	=IF(MINUTE($E4)=0,"",(MINUTE($E4)))
H4:H22	H4	=IF(SECOND($E4)=0,"",(SECOND($E4)))
I4:I22	I4	=IF(ISBLANK(OutlookSortByName!$B2)," ",(OutlookSortByName!$B2))
J4:J22	J4	=IF(ISBLANK(OutlookSortByName!$C2)," ",(OutlookSortByName!$C2))
K4:K22	K4	=IF(ISBLANK(OutlookSortByName!$E2)," ",(OutlookSortByName!$E2))
L4:L22,N4:N22	L4	=IF(ISBLANK($I4)," ",($I4))
M4:M22	M4	=IF(ISERROR(DATEVALUE(A4))," ",(DATEVALUE(A4)))
O4:O22	O4	=IF(OR(N4="dodge",N4="Codger"),K4,"")
P4:P22	P4	=IF(O4<>"",COUNTA($O$4:O4),"")

Named Ranges
Name	Refers To	Cells
OSBN	=OFFSET(OutlookSortByName!$A$2,0,0,COUNTA(OutlookSortByName!$A:$A) - 1,COUNTA(OutlookSortByName!$1:$1))	A4

Conversations with Roger Caymin-2021.xlsx
	A	B	C	D	E
1	ReceivedTime	SenderName	subject	To	Doc #
2	10/11/2021 10:45:30	dodge	Re: FW: Premium TRUE 1425: License to Kill	Codger	959 >
3	10/11/2021 10:47:26	dodge	Re: 12th Grade High School & This and that	Codger	960 >
4	10/11/2021 12:12:08	dodge	Re: Pineapples	Codger	962 >
5	10/11/2021 13:23:11	dodge	posting	Codger	964 >
6	10/11/2021 09:31:02	Codger	12th Grade High School & This and that	dodge	957 >
7	10/11/2021 09:49:02	Codger	FW: Premium TRUE 1425: License to Kill	dodge	958 >
8	10/11/2021 11:08:11	Codger	Pineapples	dodge	961 >
9	10/11/2021 12:31:05	Codger	Beach Boys	dodge	963 >
10
11
12
13
14
15
16
17
18
19
20
OutlookSortByName

 

[steve the fish]

Well your cell in A4 downwards isnt blank. You ask it to produce " ". Then in B4 you say if equals "". Remove that space in the formula in A4.

 

[MrDB4Excel]

That takes care of columns B thru E, but columns F thru H remain with #VALUE! when column E cells are blank (they really are not blank because they subsequently have the formula =D#).
So for example in cell F12 is this formula: =IF(HOUR($E12)=0,"",(HOUR($E12))). in E12 is the formula =D12, but in the attached X2lbb E12 is blank because D12 is blank because cell C12's formula: =IF(C12="","",MROUND(C12,"0:1")) results in a blank answer. All of this is located in my original X2lbb.

 

[steve the fish]

You would say something like

=IF(E12="","",HOUR(E12))

 

[MrDB4Excel]

Perfect, thanks steve the fish! This worked exactly as it should, good work.