• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search non-empty in Multiple column

O

Ozgur

New Member
Well, I've got this problem but it is kind of hard to explain in words.

Basically, I've got a dynamic calendar. Where I pick the first day and the dates on the calendar change depending on which month it is and so on...
and on this calendar sheet I have got information about a teachers schedule.
Which days and hours the teacher has given which lessons.

I can not post the file since it has many other information in Russian and formulas too. I will try to show it as a table :

sheet1-calendar.png

So from here on, on the second sheet I have this EMPTY table. I would like to fill that table with a formula which will - literally - search the lessons in the week, and give me their date and time.

So the search will work like this

outcome-ex.png


and if the code works, the working outcome SHOULD BE :

final.png




I really appreciate any help since it's been days and I've searched, asked, begged in many other forums also but no one can help...

Thank you in advance...
 
Hi Ozgur,

Welcome to the forum.

Well in the absence of a sample file, where in we can see all possibilities of data, I had created one as per your images. See the file. Sheet2 Has solution.

Please note formula in files are array formula, so they must be confirmed with Ctrl+Shift+Enter,and not just Enter.

Regards,
 

Attachments

  • Ozgur_Chandoo.xlsx
    12.2 KB · Views: 8
The test will take some time since my calendar is not weekly but monthly and I have a lot of data to enter. But for sure I will come back and post it here.

I took a look at it, and it seems to be the EXACT thing I was looking for..

Thank you so much again.
 
Somendra Misra said:
Thanks for the feedback will wait for the update from your side.

Regards,
Click to expand...

Hello again,

This is the final version with a little editing. In case someone else will need such a thing in the future I'm posting the finished file. It has Russian everywhere, but I believe that won't be a problem to understand how it works.

It has a dynamic calendar on the sheet : November.
Where you enter the first day of the month for example : 01/11/2014
and the calendar dynamically changes.
And on the Payment November sheet as Somendra Misra helped out, the formula finds the non-empty cells and then MATCHES with it's date and time and writes it into our cell.

Once again thank you so much

PS: If someone has a better idea how to do it, an easier way or a better way, I will be glad to hear it :)
 

Attachments

  • payment.xlsx
    26.4 KB · Views: 3
You must log in or register to reply here.
Back
Top