Search results

Hi Chandoo Experts, For one of my projects, I made a payroll dashboard. Everything looks good and working except I did notice that vacation time left and sick time left isn't working on the YTD side in the employee dashboard tab. I need to reduce whenever the hours are used. Can you check...

Great thanks Hui...How have you been? Staying safe I hope. Happy Holidays. Joe, Michigan.

Thank you , but I don't want to mess around with codes....

Hi Chandoo Experts, I have an advanced filter project I am working on. On the tab advanced filtering, I have a list of cars with some specs. I have the criteria range above the list. Also, I have named the ranges. So when I do the advanced filter it just won't display the criteria. Can you...

So what does that matter.....I want another opinion.

Hi Chandoo, My columns for my text project seem to be working except for a couple issues. 1) There is a comma between two last names (line 38) and there should be a hyphen. 2) On line 40, there is a comma between Van, Eaton and on line 38 a comma between Ashmun, Baker. Need to have a hyphen...

Hi Alan, I guess I don't understand the Power Quary. Is there anyway that you can update the formula to put the prefix in the first column without ruining the rest? Also can you add a formula to put a hyphen in between the two last names in the last name column? Thanks so much. Joe...

Hi Alan, Could you check out the file with the quary? It doesn't seem to be refreshing or updating. Thank you.

Cool, got it! It doesn't seem to update when I put another item in the text. When I put Miss Sophia it comes out as "MissSophia." Can I update the code if I need to update my column? Thanks so much.

Hi Alan, I was following the steps of the power query guide and I got to the part where I loaded the table onto the a new sheet. Then I got to the point where the power query editor popped up, but don't understand where to go next. If you got the time today, can you go through this with me...

I have the power query tab, but not sure where to put the code at.

Hi Chandoo Experts, Hope all is well and staying safe. I need to ask you a favor. Can you update the formula in the first name column so I can get a space between Mr./Dr./Miss etc and the first name? Also, in the last name column I would like a hypen between the last two names. These are...

Thanks AlanSidman, that did the trick, have a blessed easter.

Hi Chandoo Experts, Hope all are safe and healthy. I have question regarding my dashboard. Not sure how it happened, but when I select a pitchers name from the dropdown list on the pitcher tab, I get this error: it goes to visual basic with an "expected end sub error." This is kind of out of...

Hi Chandoo Experts, Hope all are staying safe. I was wondering if you can take a look at my step chart. I've added some dates towards the end of the table but it doesn't seem to be updating on the chart. Can you show me what I'm doing wrong? Thanks Joe, from Michigan.

Hi Chandoo Experts, Hope you are safe and well. I was looking at this chart I made a while back and thought how about a coronavirus chart. Do you have any suggestions on how we can update this chart to make it a coronavirus chart? Thanks, Joe from Michigan.

Hi Shrivallabha, It's almost what I wanted. Looking to get Jamestown Circle /Slaton Drive /North Silver Pines Drive in column f. Also need Grand Haven in column H. And no comas after Northville Grand Haven and Bellaire. I applied the formula in this file for you to look at to see what I mean...

Hi Chandoo, I would like to use this formula: to find the other spaces in my text. There is about 8 spaces in my text and I would like to extract the text from each space. Not sure how to find the other spaces. I want to get the last name, street no, street name, city, state, and zip...

Hi Nashraze, I'm still looking for the formula to use in this situation. Thanks, Joe

Thanks srinidhi, I did that too. But I was hoping to get it a formula....

The main data is in the text tab..in a3-a7 is an example of where the full name and address with the city, state, and zip in one cell. In column C, I extracted the first name using the left function. In column D, I used the mid function with three finds to locate the spaces. In column I, I...

Hi Chandoo Experts: I've got a text project that I am working on. I've got the full name and full address in one cell. I would like to extract the text into separate first, middle, last, street no and name, city, state, and zip. Without using the text to columns feature. I've notice that a...

Hi Bluesky63, Thanks for the response. That is cool. Except when I try to refresh, it says the initial data source failed. Not sure how to correct that. Can you tell me how? Thanks, Joe.

Just wanted to say thank you to all of you for the responses. There is some great stuff here and I appreciate you helping me out. Chandoo is awesome.

Great, thanks herofox!