If you have a unique application for an XLOOKUP, leave a comment below.

TEXT to COLUMN is your friend when you want to refresh a column with a new format quickly!😀

@OfficeMystic

Жыл бұрын

Yes! If you apply a format to a column, it might not actually take until you activate it by hitting F2, clicking inside it, or the text-to-column trick.

Easy to understand.

@OfficeMystic

Жыл бұрын

I'm glad it was useful! Thanks for the comment.

put the =LEFT() inside of the =VALUE() function and it'll look for the the number 400

Your beard gives you an aura of wisdom

Hey, thanks for the nice explanation. I have a table and I need to set a formula with multi conditions. Can you help me which formula and how I'm gonna use it.

good evening: I wish you if there was a way to add the new functions on excel 365 to the old versions of Office

Why not use lookup_range & "*" instead of using Left function?

Hi I work for a precast construction company. We want to pull out panels that are the exact same on that data sheet to a column based of a set of values, let's say heigth, width and other construction parameters. I think this is the fucntion that would do that, i am right? I havent tried it but maybe some hints of how to go about that would greatly help.! thanks for your videos

@OfficeMystic

Жыл бұрын

Thanks for the compliment! It sounds like you need an XLookUp with multiple conditions. I made a video about it: kzread.info/dash/bejne/lGyDlqOiopTeYMY.html Hopefully that helps, if not, I don't mind taking a look at the spreadsheet.

Hello, you don't have a video on the FILTER function so I am posting this question here. I have an employee leave tracker spreadsheet where I want to filter for the employees who are off a particular month. I have 2 date columns: Start Date and End Date. I have a dashboard that shows the leave booking by month. I can filter for the employees who have booked their leave for a particular month, BUT if the duration of the leave stretches to the next month or the month after I cannot show them when I change to the next month because I am filtering on the Start Date only. How can I filter so that the employee shows in all the months where they will be absent? I think I have to incorporate the End Date into it, but I have not got it to work so far.

@OfficeMystic

14 күн бұрын

Hello, sorry I've been away for quite some time, but I am returning to the channel. You probably already have this figured out, but I plan on posting a video on this topic tonight.

@kimyenchu

14 күн бұрын

@@OfficeMystic Hello, no I have not figured it out. I have created a workaround by showing 2 months side by side ie. January and February.

@OfficeMystic

14 күн бұрын

@@kimyenchu I posted the video: kzread.info/dash/bejne/h6hsw5iLpdu6nJc.html