I have created this database so I could select a dept # and have all records for that dept # listed in a new table on same sheet.
Problem I am having is the formula is working in only some of the cells, I can't figure out how to make them all work.
I have created this database so I could select a dept # and have all records for that dept # listed in a new table on same sheet.
Problem I am having is the formula is working in only some of the cells, I can't figure out how to make them all work.
First thing I see is that your headers which you reference through Indirect are not the same as your named ranges which is why you are getting #REF. i.e. header is "Last Name" Named range is "Last_Name"
Hope that helps.
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
Thank You, that did help for some of the errors I had. just a few more left to look over. again thank you
I have one last fix to be done so this works perfectly. Hope you can help. In cells that are blank are coming up as zero's. How do I get the blank cells to extract over as blanks using the formula I already have?
Thank You
You need to nest another IF statement in there unfortunately, so in AI5 for example would be the arrayed formula
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks