Search results

Thank you @Monty for the suggestions, will try to explore them.

Hi All, In my dashboard, I want to add a read-me page. This page will be no calculation or numbers involved. However, will consists of assumptions, formulas used for various metrics in the dashboard, etc. Is there any good visualization or combination of visualization available in PowerBI...

Thank you ETAF! This works. I think i had lost my mind. :D

Hi All, I have data of planned and actuals for every team member across different projects in specific format given below. I have also attached the sample workbook. Planned Actuals Planned Actuals Planned Actuals Planned Actuals Planned Actuals Planned Actuals Team Members Project1...

I was trying to get some help with number formatting, and for some strange reasons, it was throwing some error stating cannot perform this action. Wait for 140 seconds and try again, etc. I tried multiple times. Later, I realized some of it did get posted. this is not intentional, kindly...

Hi All, I have a table of different KPI metrics collected across teams in excel files. Each KPI may be measured in different units. Hence the Targets are in % or scale of 1 to 5, or simple an absolute number, etc. The sample data and format of raw data collection table is as follows...

Hi @vletm, Thank you for taking a loot at my post. I apologies for not able to put up the sample file, I will try to upload one shortly. meanwhile, request if we can assume the My Data starts from A1 cell with header. I will tweak and adjust to columns in my actual file accordingly...

Hi All, Firstly, I am not able to upload file due to restriction. However, will try to provide full clarity of the data and my requirements. A typical a project would have following sequence of Steps: Sequence Standard Steps 1 Request Submission 2 Understanding Request 3 Raise...

Thank you @Peter Bartholomew!

Hi All, I am struck at a strange problem. I have dates in multiple columns, and use the max() function to get the maximum date from those multiple columns. This works fine when the data is in range. As the data now is formatted as Table, I need help on how to use Max() with column names as...

LOL :D yes, I just realized it as well. thank you. Regards, Prasad DN

Hi All, I used to write formulas for such requirements and it is being quite some time and l lost touch. I remember using array formulas - sumproduct, mmult etc but not able to get the right combination now. :( I need formula for the below scenario. count no of columns where we have numbers...

try explaining your requirement, if you have to do manually for couple of records as example..

try this.... i have given the code for two text boxes.. you can keep adding as many as you need. Private Sub CommandButton2_Click() On Error Resume Next quantcoup.Text = Abs(Not VBA.IsEmpty(ddc1.Value) And Not IsNumeric(ddc1.Value)) + Abs(Not VBA.IsEmpty(ddc2.Value) And Not...

hi, does an VBA solution work for you? or looking for only formulae based solution? Regards, Prasad DN

how does TEXTJOIN() work? is this available in any specific version of excel?

Hi All, I was trying to understand the details in the below link: https://chandoo.org/forum/threads/word-macro-for-inspecting-document-and-removing-3-types-of-property.9435/ I am trying to look for a solution to the below scenario. This is related to MS Word files. the word files i have are...

Hi All, Wish I could have found some way.. Let me try if I can put validation in the source area itself. It is going to be a tough task... :s Regards, Prasad DN

Thought of sharing the detail on screen, just in case any of you have issue opening the excel attachment: Given Text 08/18/2017 8 hours expected output: 8/18/2017 and 8:00:00 in two columns Given Text 08/16/2017 7 hours 10 minutes 8/16/2017 and 7:10:00 in two columns Given TExt 7.27.2017 -8...

Hi Neeraj, please try to rephrase your requirement.. or try IFerror() Regards, Prasad

Hi All, This situation of mine may sound more like natural language processing... the simplest would be to fix the format at (root level) who creates this text. Unfortunately, that is not in my control. so i have to find my workaround. I am sure with such huge excel knowledge base resource...

Hi All, i have simple macro file created. The MS Excel 2010 version, and inside Citrix environment, when i open the file, it takes almost 15 mins to open the file. once, it is open the functionality of macro is with good speed. The challenge is only when the excel is opening the file. It...

I am exploring the post : http://chandoo.org/wp/2012/11/27/extract-subset-of-data/

Hi All, lets say i have information of records like in attached file, Data tab. The data consists of account name, salesman name, 5 columns of keywords, email sent and received, etc. What I am trying to achieve is in Search Tab. I would like the user to put any word in the search criteria...

Hi, I tried the exact same, but it does not got sorted. Is it got something to do with outlook 2010? and it is inside Citrix Environment. In fact, some times it works and most of the times it won't. and, that is what actually keeps me worrying. :( Regards, Prasad DN