Search results

Thank you @ AlanSidman, @pecoflyer, and @bosco_yip, you've all provided me with different solutions expanding my options in the future. Wishing you a beautiful week ahead, mayhem

Help, it's been years since I used Excel and I need to update the email addresses (Column G) in the 2nd tab (22-23) with email addresses from the 1st tab (21-22) where the conditions of Columns A match (Centre Name). If it's possible to populate based on Columns A & C matching would help even...

Thank you so much Peter, what a simple and effective solution, I'd been racking my brain with iF and VLOOKUP functions to no avail. Have a great day

Greetings I have 2 sheets and need to transfer the Students Taken in 2018 information from SiteTotals.csv sheet into Schools for CRM matching the schools. Please help, as I', unsure what is the simplest way to achieve this without manually copying each cell and pasting when working with a...

Thank you Ninjas fr your time and helping out. I'll read up on the recent CF post too. Best, M :)

Hi Excel Geniuses I've attempted to create formulas here that reference texts in column H to fill the entire row i.e. 1. "Open" returns no fill for the entire row 2. "Complete" or "Complete *more text*" returns blue fill for the entire row 3. "In Progress" or "Awaiting *more text*" or "Review...

Thank you Narayan, you're the best :)

Dear Chandoo What's the best formula to split a cell by case. In the below example, how do I separate 15 Potts St from RYDE NSW 2112. 15 Potts St RYDE NSW 2112 Thank you

But you LOVED helping me out! ;) Thank you so much for your help with this, it is much appreciated. I can do the remaining months myself. Have a beautiful week ahead and Happy Holidays Mayhem

I'd be overwhelmed with gratitude and would love to learn from you how it could be achieved. Shukria, Gracias, Merci, Arigatou :) Mayhem

Same colour as per Setup legend please. Thank you so much I appreciate your time M

4. That's right, thank you for checking, I can live with that 5. I did manually start to colour some of the Calendar but stopped when I realised the scale of the task at hand. Yes I'd like to automate the Calendar tab based on the colours in Setup. I've done as you suggested, giving each colour...

Thanks for the quick response. 1. The date population in Setup is manual 2. The calendar I copied, used conditional formatting. If manual is easier, I could use that instead unless there's another way to distinguish legends i.e. coloured text instead of cells 3. I'd like the calendar to display...

Hi Narayan I appreciate you provide advice, I hope I didn't sound demanding :) Apologies, my articulation was poor at best. - I have 2 tabs: Calendar and Setup. - Under Setup I have populated dates and legend that I need reflected in Calendar tab (Anything else in Setup tab, I don't...

Pranam Narayan, thank you for your input on the following thread but I wasn't able to understand so I followed the link sent by Hui and had one more query. Pls see thread and let me know if you can help as my deadline for this task is fast approching...

Hi Hui & Narayan Thank you for your advice. The link from Narayan was sadly Greek to me and the link from Hui was fabulous but once I'd downloaded the calendar and populated with my dates, I still didn't know how to automate the conditional formatting for my events which fall under 4 different...

Dear Chandoo Gurus I have Excel 2007 and am trying to creating a calendar from data. As I will need to modify the data on a regular basis I need to create a calendar that amends automatically with each update to data. Please see attached and advise what is the most efficient way to create one...

Shukria & Thank you, Narayan... True to your name, you are Absolute... No cell reference pun intended! You simplified an unnecessarily complicated formula Mission accomplished, have a good day :)

Dear Excel Whizzes & Wizards I am trying to match a code to one s/sheet from another within the same workbook. I pretty much copied a formula sequence from my predecessor's files to no avail. Please take a look at my formula in Cell V3 of my dummy file and advise where I have gone wrong...

Dear SirJB7 Thank you so much for the quick response, your Ninja skills are swift and most helpful. Have a good day :) p.s. What language is the initial string if not English?

Dear Chandoo Please forgive me if the title is not accurate. I am a fairly basic user of Excel and have just started a role that requires much reporting. I have an email exclusion list and would like to know the best formula to search current data to exclude the emails from my list. I have...

Thanks Hui but I still don't understand the instructions presented. Assuming we are referring to the example in the tip, the 3rd row would relate to #, Activity, Start, End etc, and 3rd & 4th columns would relate to Start and End. If my Project Plan was identical in structure, which cells would...

Dear Chandoo Under your tip entitled: Conditional Formatting in Excel – 5 Tips to make you a Rockstar, I tried tip # 2 for a gantt chart and it didn't work for me. There are 3 bullet points, I followed the 1st by creating the table structure. I am unclear about the 2nd and 3rd bullet points...

now how would I amend this should the cell reference be a colour. Is that possible?

Thank you so much Guru Chandoo, I am overwhelmed with gratitude, it came in at the right hour :)