Forum Discussion
Excel Formula Help
Woops. I thought I'd fixed that. These are tricky, and you recognized the error that slipped by me.
See if this is doing it now.
So far as multiple purchases from A17, so long as each appears on its own line, this will work. And it sure looks as if each order, each purchase, is on a row by itself. Said another way, as long as there aren't two module codes on the same row for any one purchase, this function will work as written.
You are awesome Sir! haha. we are both learning haha and thank you for teaching and explaining it to me. Unfortunately, there will be the same entry as far as module goes. So there might be A17 module that purchases multiple times from different vendors and price.
another question for you. why is that function pulling different modules from different districts? MRD is showing 34 and 58 which would be on different districts.
Woops. I thought I'd fixed that. These are tricky, and you recognized the error that slipped by me.
See if this is doing it now.
So far as multiple purchases from A17, so long as each appears on its own line, this will work. And it sure looks as if each order, each purchase, is on a row by itself. Said another way, as long as there aren't two module codes on the same row for any one purchase, this function will work as written.
Yes it is Sir! I love it!! Thanks again for your time and help
Glad to hear it. It was, as already noted, a learning experience for me too. So thanks for asking the question in the first place. This forum is an awesome place.
Yup that seems to be working. Sir i cant thank you enough for your time and help with this! I really appreciate it!!