User Profile
Alicia1250
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Formula or Function???
Thanks for reply Lz but for some reason even on example I am getting error and returning either blank or #NAME? response for anyone other than Johnson. I love the idea of a separate sheet though. Much easier for personnel then my huge spreadsheet. My table is much more complex then just those simple headers and the headers are not even in same row. Unfortunately it was a sheet not originally designed by me. My names are in G23 to G435 and my course title headers are in AG16 to BQ16. Not sure if even adaptable to the formula you wrote? Thanks again for you time! If you have other ideas I'm open! Alicia2.3KViews0likes2CommentsRe: Formula or Function???
Quadruple Pawn, Thanks so much for your response! It worked perfectly when I utilized in a table as above but when I tried to duplicate it in the actual table it didn't work for some reason?? My names are in G23 to G435 and my course title headers are in AG16 to BQ16. I am attempting to make BU21 my input box and added formula in BU24:BU50 with no results. Here is how I rewrote the formula (would you mind looking at it and see if you see any errors??): =IFERROR(INDEX($AG$16:$BQ$16,SMALL(IF(OFFSET($G$21,MATCH($BU$21,$G$22:$G$535,0),1,1,7)=1,COLUMN($G:$BQ)),ROW(1:1))),"") Thanks again! Alicia2.2KViews0likes2CommentsFormula or Function???
I have an excel spreadsheet that is huge (over 400 names and over 30 courses) and I need an easy way for a person to see their specific course requirements. Not sure if they would click on their name and get a link or popup or go to another sheet that has some formula that gives them just their courses. Any suggestions or assistance would be so appreciated!! Tried tons of things but can't figure it out! Here is an example: Name BLS ACLS TNCC Harris 1 1 Johnson 1 1Solved2.7KViews0likes10Comments
Recent Blog Articles
No content to show