Convert if formula to array formula

[Vishaal]

Hi,

We have the following formula

=if(c1,c1,if(b1:b<>"",$A$1,""))

now we want to convert it to an array formula so that it will work on complete c column

Help pls

 

[Darren Bartrup]

If you're using Excel 365 you can just enter =IF(C3:C7<>"",D3:D7,"") and the formula will spill down. If not in 365 highlight the cells you want to put it in and enter it using Ctrl+Shift+Enter, but you might as well just put =IF(C3<>"",D3,"") in the first cell and drag the formula down.

That is what you want isn't it? Or are you expecting a single value returned based on the data in the whole column?

 

[Vishaal]

I dont want to drag formula because we are getting all other details through "Array Formula" so if we will add here new row

We need to copy formula again here but if we do this through array it will auto add formula

 

[Vishaal]

sorry,

i am explaining here all the details again,

we want only array formula because if we add any new row, then we need to copy the formula again every time and its a large data so we do not want to check and copy the code again and again.

question sheet here
query is if we select or change any name on column B, it will add the timestamp in column C, from A1 or add the current timestamp,

06-09-2020 14:04	0.3625	01-08-1900 07:12
Indent Reference Number	Test	Time
CFD-1	Me
CFD-2	You
CFD-3	Other
CFD-4	Me
CFD-4	You

Answer sheet here

06-09-2020 14:04	0.3625	01-08-1900 07:12
Indent Reference Number	Test	Time
CFD-1	Me	09-06-2020 13:44
CFD-2	You	09-06-2020 14:44
CFD-3	Other	09-06-2020 15:10
CFD-4	Me	09-06-2020 16:15
CFD-4	You	09-06-2020 17:30

 

[Vishaal]

i have just posted this for clarification only, no intention to bump the post

take your time.
thanks for creating such a great form.