At E2 (sheet Advanced Filter), Select =113 300 or =10
To get results.
2014-08-14 22:12 GMT+07:00 Paul Schreiner schreiner_p...@att.net:
I don't believe you can do it with a FORMULA.
But you can do it with a Change Event macro.
You would create an autoFilter for rows 5-###
Then,
Good try, but no what I simply need is an some kind of event mechanism
to make things as idiot proof for the operator using this.
In cell K1 - The operator has the option of entering either A, D Or P.
A = ALL records
D = Only records where cell E6 onwards 113000 AND ALL BLANK RECORDS
Dear Mr Joshi.
Thank for your consider.Enclosed is file to you reference.
Best regards
Son
2014-08-13 16:05 GMT+07:00 Vaibhav Joshi v...@vabs.in:
hi
can you share a sample data in excel sheet.
Thanks
On Wed, Aug 13, 2014 at 1:57 PM, son nguyen sonnguye...@gmail.com wrote:
Dear
Hi,
I do not have much knowledge of VBA but wanted to learn it. Can you refer some
book? So that I can start with the self study.
Thanks,
Ruchi
Sent from my iPhone
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook
Try Excel Power Programming by John Walkenbach
and for online tutorials visit
http://www.andypope.info/links.htm#forums
On Sat, Aug 16, 2014 at 9:24 AM, Ruchi Sharma simpliru...@gmail.com wrote:
Hi,
I do not have much knowledge of VBA but wanted to learn it. Can you refer
some book? So
Dear All,
I am trying to calculate Written Down Value Rate for calculating
depreciation on the basis of WDV method by using the following formula.
Rate = [1 - (Scrap Value / Total Cost ) ^ (1/Life) ] * 100
If the life is in Number of Exact years, the rate derived is accurate, but
if the life of
