i have the following formula
=allocation(input!$A$2:$AK$10000,B7,B9,B11,E6,1)
and i need to find the value between "AK$" and ",". In this case it is 10,000, but it could be any number. Could someone supply me with VBA or spreadsheet formula to do this. Thanks.
=allocation(input!$A$2:$AK$10000,B7,B9,B11,E6,1)
and i need to find the value between "AK$" and ",". In this case it is 10,000, but it could be any number. Could someone supply me with VBA or spreadsheet formula to do this. Thanks.