Hi Melinda I am assuming you only wanted to display the rows that your colored. 1) Select cell A5 of your Pivot Table (Adm) 2) Select Pivotta...
Hi Annamaria Try unticking the Ignore Blank option in your DV. Sunny
Hi Paul 143K INDIRECT and OFFSET, no wonder your calculation slowed down to a crawl. 143K VLOOKUP will also cause a problem. I would suggest ...
Hi Abbas No problem. Glad to know you got it working. Sunny
Hi Abbas I am confused. You wanted to count the number of entries where column C contains IT448 and column D must be empty but you expect the re...
Hi Irfan I am assuming: 1) You want to use the built-in form found in the QAT - More Commands - All Commands - Form... 2) Your data is in the...
Hi Paul Having thousands of formulas using INDIRECT and OFFSETS will definitely slow the calculation to a crawl. Both these functions are volati...
Hi Abbas What is your expected result in C38 (periods achieved) and C39 (percentage of achievement)? Are you trying to do something like this? ...
Hi Abbas What are you trying to achieve? It looks like you are trying to do 2 things in one formula. If you want to count cells equal to IT44...
Hi Abbas There is no attachment
Hi Anjali There is no attachment.
Hi Irfan I tried converting your Data table to a normal range and it seems to work. Even your original file is working. You will need to change ...
Hi Irfan The last file I attached Finance-Diary-Inprocess3.xlsb is working fine in my Excel 2013 (32-bit). I don't know what else I can do to re...
OK. I finally got a copy of Excel 2013 to test. Hope this time it works as I have tested it many times and it looks OK. Sunny
Hi Vivek As far as I am aware, you cannot use INDIRECT with a closed file. You will need a macro that auto open the required file (when you open...