Snap42.jpg
Snap40.jpg
Snap41.jpg
I used a formula to extract only nonzero values for Price.
Using IFERROR will slow down ...
Would not it be nice to use IFERROR?
* Unfortunately, we have to solve it with a function.
Snap42.jpg
Snap40.jpg
Snap41.jpg
I used a formula to extract only nonzero values for Price.
Using IFERROR will slow down ...
Would not it be nice to use IFERROR?
* Unfortunately, we have to solve it with a function.
Last edited by chief_abound; 03-12-2018 at 11:08 PM.
you can use the filter or
use an macro/VBA.
array formula as well.
Last edited by BoredWorker; 03-12-2018 at 10:54 PM.
Hi! BoredWorker
Yes - it is reasonable to do so ...
(Thank you so much! )
to avoid slow,
please avoid to used full column like "A:A", please use "A2:A1000"
u may try below similar formula.
Formula:Please Login or Register to view this content.
if u refuse to update the range every time add in new data, please transfer the data to a table. (shortcut key: Ctrl + L)
the formula change to
Formula:Please Login or Register to view this content.
Last edited by BoredWorker; 03-15-2018 at 11:31 PM.
Hope you can learn every time you visit here.
If you still confuse on how it work, kindly ask or go to
i) Formula - Formula (Ribbon) > Formula Auditing (Section) > Evaluate Formula > Evaluate; or
ii) VBA/Code - Click F8 to see how it work step by step.
It it take care of your question, Please:
Mark tread as [Solved] [Thread Tools->Mark thread as Solved];and
Click *Add Reputation to thank anyone solved your question.
Thank you so much!
i make some mistake in the formula.
please refer to post#4. i revised already.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks