Search results

Hi Sarah, The most easiest way to have this done is without a VBA and by using Power Query. Step 1. I converted the data in databook as a table and saved the file in the desktop. Step 2. In a new spreadsheet, PowerQuery > From File > (navigate to desktop) choose the file "Databook", selected...

Hi Abhijeet, Request you to please confirm if you want to list the cell range in P2? Kind regards, A!

The more easier way to do is by using Power Query. More information here: http://www.powerpivotpro.com/2015/01/power-query-for-excel-combine-multiple-files-of-different-file-types/ Kind regards, A!

try using a much easier solution using powerquery with which you can just refresh it to retrieve the data once the source file is placed in the correct folder. more information here: http://www.powerpivotpro.com/2015/01/power-query-for-excel-combine-multiple-files-of-different-file-types/...

Hi Abhijeet, There are two ways to do this. assumption here the search text "UA" is in cell P1 then use the search function to list it =IFERROR(SEARCH(P1;B2;1);"") or if you want to count the number of occurrence use the following =IFERROR(LOOKUP(2;1/SEARCH(B2:O2;P1);B2:O2);"") hope this...

Hi Anand, Use PowerQuery to consolidate files. Power Query is an add-in from microsoft which you can download from here (32/64-Bit) https://www.microsoft.com/en-gb/download/details.aspx?id=39379 Follow this kb/blog/videoes to consolidate your files. Using this way all you would have to do is...

Hi Mahantesh, I would use Sumifs and something like this. The type 6 is missing a '-' in cell F6. =SUMIFS($B$3:$B$40;$A$3:$A$40;$F$6;$D$3:$D$40;$F$5) Hope this solved the issue. Kind regards, A!

Thank you deepak, it worked like magic. A!

Hi Deepak, Here is the sample file for your reference as requested. Thanks in advance. A!

Hi team, I'm trying to lookup values based on partial search but because it is partial search it does not lookup the complete list. for example: [Lookup field]Column A: 12345 [Data field]Column E: 45678, 98765, 12345, 109876,456312 [Data field]Column F: Testing the formula i've been using...

Hi Hui, Sorry for the confusion. There are 2 worksheets. One is "Data Sheet" and another is "Input Sheet". The Datasheet is the sheet with data. The input sheet is where teams can provide their inputs. The input sheet initially will list values from the data sheet. However, if the team...

Thank you for this Hui, this does help me for the single entry updates. However, if we one does not want to input ID's but just update it as a bulk update. how can it be done? Thanks in advance...

Thank you for this updated sheet Hui. However, I was looking to update information in sheet 1 to sheet 2 only with a command button to update information when required. Can this be done? many thanks in advance.

Hi team, I'm sure there is an easier way to achieve what I'm trying to do. Attached workbook includes 2 sheets from which I'm trying to update values based on sheet 1 to sheet 2. sheet 1 includes the updated values for columns Street Name, City, country & value which I would like to have it...

Hi Thomas, The easiest by creating a named range and I've tried the same in your sheet. Attached is for your reference and yes, you can also use the formula as suggested by Narayan which is also easier. Kind regards, A!

Hi Thomas, Is it possible for you to include a sample file to have this simplified as requested? Kind regards, A!

Hi Nitin, Give it a try with Data > edit links > change data source. Hope this helped. Kind regards, A!

Hi R_2, Attached sheet includes the conditional formatting as required. Hope this helps :) Regards, A!

Hi Yaseer, You can achieve this desired results in two ways. One is using advanced filter(s) or using index match like the attached file. You can choose the options from the top and based on your selection you can see the list update in the results sheet. Hope this helps. Kind regards, A!

Hi Richa, What I understand from your query is that you are looking for is like an activity tracker. Make use of the following which is quite helpful http://chandoo.org/wp/2009/06/25/todo-lists-project-tracking-tools/ http://chandoo.org/wp/2009/10/06/project-status-dashboard/...

Hi Michael, Why use vba when this could be resolved using excel function? See attached file for example. Kind regards, A!

Hi Jagdev, Create a custom currency value first like mentioned below and the cells where u have the values just apply the formats should work. Format > custom > #,##0.00 Kind regards, A!

Hi Mike, Follow the below steps for excel 2010 and above File > Options > Formulas > [calculation options] > uncheck the box which reads recalculate workbook before saving. This should do the trick. Kind regards, A!

Hi, I think you wanted to have something like this...insert the below formula in cell a1. =IF(B1="O","D",IF(B1="E","U")) Regards, A!

Hi Narendra, Welcome to the forum. I'm not sure which application from which the snapshot is from? or attach the file to get some help. Kind regards, A!