reliable

Hi there, this has been driving me crazy... I have a range (EF60:IV60) and I need to return the last value which is not blank or 0. I'm also looking to return the column that this value is sitting in... (I've tried this with conventional formulas, but it is not reliable for some reason) If...

Does anyone know if there is either a Microsoft add on or, a reliable add on to have Excel create QR codes? Thanks.

Yesterday, accidentally deleted some of the records in MDB file. Any quick and reliable way to fix it?

I have a trimmean formula that looks at data daily and the result is set up to measure quarterly. at the beginning of each quarter the info is not reliable as there is insufficient data. I was thinking if a took the results of the past quarter and added it to the current quarter the first few...

Hi, My question is more theoretical. We have a file that requires the use of complex formula for a large set of data. The XLS version of the file is much faster than the XLSX or XLSM version. I understand why the XLS file is faster and explain it to one of the managers. Whoever the manager...