LinkBack URL
About LinkBacks
I have a simple spreadsheet, where items are in column A and their prices in column B. How to set that items without price do not get printed?
I have a simple spreadsheet, where items are in column A and their prices in column B. How to set that items without price do not get printed?
You can either filter out the blanks and zeros or you can use formulas to move all non-zero results to a separate spreadsheet and print that sheet. There is no command to just print the non-zero values as they appear on the screen. The simplest way is to filter.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Is there a way to do this automatically? Because when I open spreadsheet template, it already has all items, but no prices. I then enter prices for some of them and I want only those to actually get printed, while excluding all other items. Thanks!
Here is the transfer of data to another sheet using arrayed formulas
Arrayed formulas need to be entered using CONTRL SHFT ENTER instead of a simple ENTER. If done correctly you'll see brackets {} around the formula
In Sheet2 A3 dragged down
=IFERROR(INDEX(Table1[Item],SMALL(IF( Table1[Price]=0,100000,ROW(Table1[Price])-2),ROW(A1))),"")
In B3
=IFERROR(INDEX(Table1[Price],SMALL(IF( Table1[Price]=0,100000,ROW(Table1[Price])-2),ROW(A1))),"")
See attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks