for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

larkim Nov 2019 4:09pm, 28 Nov 2019 9,619 posts	Quote Pin larkim Copy that formula across 9 columns, with locked references as $A$2:$A$114 $L2 B$2:B$114 Perhaps add some =if(iserrror()) clause in there too to aviod #N/As
larkim Nov 2019 4:09pm, 28 Nov 2019 9,620 posts	Quote Pin larkim I meant the non-named fomula, btw
larkim Nov 2019 4:19pm, 28 Nov 2019 9,622 posts	Quote Pin larkim Scratch that, it doesn't work for multiple "Alberts" in Col B / C / D etc of course
Diogenes Nov 2019 4:23pm, 28 Nov 2019 42,859 posts	Quote Pin Diogenes I've also noticed that it only works on one column, not multiple columns, even without the array
SPR Nov 2019 4:31pm, 28 Nov 2019 29,728 posts	Quote Pin SPR I think adding helper columns to allocate one column per specific approver might be the way to go.
Diogenes Nov 2019 4:43pm, 28 Nov 2019 42,860 posts	Quote Pin Diogenes Yes, I'm in the process of doing that. Thanks all.
GregP Nov 2019 9:33am, 29 Nov 2019 116,432 posts	Quote Pin GregP Okay this must be easy but it's stumping me. I want a spinner with the cell it's changing in the middle. That can't be hard, surely?
um Nov 2019 10:01am, 29 Nov 2019 1,444 posts	Quote Pin um Greg - you mean between an up & down arrow? Or will 'to the right of' (or left) do?
Diogenes Nov 2019 10:59am, 29 Nov 2019 42,879 posts	Quote Pin Diogenes Another question if I may: Is there a way to apply a change to a range of cells to update a value where that value is not blank For example, the logic is "IF A2 IS NOT BLANK THEN A2=A1" The purpose is to replace the name of the person with a document number. I want to apply this to a range A2:Z10 I'm going to need a helper column, aren't I?
SPR Nov 2019 11:07am, 29 Nov 2019 29,736 posts	Quote Pin SPR IF(A2<>"",A1,?)