Formula to move certain information in a column to a table that meets criteria?

Hi
I am running a program in excel and I have macors that can do all the formulas but I can't get it to do a vital part. Here's what I have

Col A counts the barecodes - countif($B1:B$1,B1). Col B is the barcode ex: 06950290B0524123840022747. Col C shows me the code - if(B1="",0,MID(B1,5,5)*1) ex: 50290. Col D gives me the date - if(B1="",0,MID(B1,12,5)*1) ex: 52412. Col E gives me code and date together - (C1&D1)*1 ex: 50290052412. Col F counts all of the different codes/dates - countif(E:E,E1) ex:116 (in this case). Col G counts each barecode incase there are duplicates - countif(B:B,B1). Col H gives me the item # - if(B1="",0,RIGHT(B1,5)*1 ex: 22747. Col I shows if an item is missing if(H1=H2-1,"OK","ERROR"). Col J shows the entire date - MID(B2,11,6) ex: 052412. Col K, Col L and Col M are for checking between different codes/dates aka batches - if(J1=J2,0,1) for Col K, and for Col L - if(C1=C2,0,1). Col M - SUM(K1:L1).

Col N sorts out the different batches by code/date based on all the barecodes within those - if(M1 0,MID(B1,5,12),0). Col O would show the amount of each batch - if(M1>0,F1,"") so 116. All formulas are extended 350 rows.

Here is where my problem lies, I am trying to find a way to read only the batches from Col N and the amounts from Col O and put them in a table without having to make the table 350 rows. My table has to be small and only show the number of batches. In this case out of 350 rows, there are batches and amounts in Col N and O in rows 116, 195, 210,225,226,254,270,334,349 and 350, the rest have zeros based on the formula. So I want a table to show those 10 batches and 10 amounts in 10 rows with a column for batches and another column for amounts one after another, is that possible, are there some formulas that will allow me to do this?

Please help.
Thank you

Hi and welcome to the forum.

Please note the forum rules about thread titles - here's the default response from the system.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



Since this is your first post, on this occasion I'll change the title for you, but please remember with future postings.

Cross-posted at Ozgrid

MikeTruth,

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).