$$Excel-Macros$$ GOAL SEEK

2017-05-12 Thread Izhar
look at the attachment when we click on GOAL SEEK tab, place in the sheet, we see column E filled with the help of macro but if we want to apply a formula then how can be it possible. Is there any possibility. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ Subtotal function

2017-05-12 Thread Abdelrahman Noaman
On 12 May 2017 at 06:58, Izhar wrote: > rking in s hi Change it from =SUBTOTAL(9,J2:J1399*1*) to =SUBTOTAL(9,J2:J1399*0*) Thanks & Best Regards *Abdelrahman Gomaa | *Supervisor Receivable Accountant* | *Cancun Beach Resort & Spa Address: 102 KM Suez - Zafarana Road, Ain Sokhna, Egypt Tel