Hi All,
Thanks in advance,
we have attached a sheet in that we want to if in column C,F,I,L have any blank cell then it will show column "A" value, we are getting the value with "if" formula and also getting the value with "Arrayformula" but if we use IF function then we need to drag and if use Arrayformula then we cant use that column because Arrayformula will show the error
We want only the value if condition meet and next sheet, basically we are creating a dashboard, no drag and no arrayformula
because we need to add and use other details also here
We have given a sample data only and we have large data, i mean we have column till "ND" and row 500
also posted in
https://www.mrexcel.com/board/thread...1138362/page-2
Bookmarks