Search results

Hi team, I have been trying to solve the below but for some reason, I cannot find a way...any help would be of great help. Attached is a sample workbook for reference. The workbook has the following, the first table has products with a combination of products, these are combinations that are...

Hi team, I'm trying to retrieve header information with list of all unique values in columns from different worksheets. Attached is a sample sheet with the desired output, i'm not sure if index and match can be used to create as listed in the output sheet. In the output sheet lists the...

Hi team, I'm trying to do the following. without delimiting the text string with comma as separators, I would like to count the length of characters in the below string and add 0 after AD if the number of characters is 6 and if 7 I would like to leave it as is. Having said this, the occurence...

Hi, Am trying to use both search and lookup function in data validation but not able to use it. Any suggestions to use other combinations which can help me search a text and lookup for possible options to list values? =IFERROR(LOOKUP(2;1/SEARCH(C3;a1:a20);b1:b20);"") Thanks in advance. Kind...

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 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, In the attached spreadsheet I'm trying to fill in the blank cells for Columns A thru F automatically using Special > blank cells. However, it does for the entire column which is not what I want. I would like to fill in only when there is a value like shown in the desired output. Column A -...

Hi team, I have a list of 5 sheets and they work in a sequence. I have to run them everyday and it takes 2 - 3hours every day for every file and I'm looking for a solution with which can run like batch update all by itself update like the below: File 1: runs the macro at 16:00hrs, saves the...

Hi team, I'm very sure that I'm doing something wrong in the below code because of which everytime it shows up debugging error stating 'copy method of range class failed'. Any suggestions / advise? I'm trying to copy the range E4:N4 to E6:N60000 with formulas in the same worksheet. I tried...

Hi, I have a large amount of data and I'm need to pick up data like in the attached sheet. I could use index match to pick up the related items but has its own limitation and I'm stuck with this puzzle now and i think i need a vba code to run the index match to pick up this view. Please help...

Hi, what is the correct way to include a formula to a filled column range for example Column A is filled from A1: a38 and I want my formula to included in column A39 what should be the syntax? I'm using the following formula to identify the last row lastrow...

Hi, I'm trying to create loop for the following. Loop 1: insert 2 rows for every entry in column A Loop 2: Copy the formula in b1 and paste in b4 and then b7 and then b10 until there is an entry in column A Loop 3: a. Copy the formula in b2 and paste it in b5 and then in b8 and until there...

Hi, I'm trying to pick up multiple results using index and match and from that create another index and match to pick multiple results. I dont know if there is a simpler solution for this. I'm also not sure how to do if there more than 10 results to show up in one cell and then replicate the...

Hi, I'm trying to get results for a survey and the question is like this. the survery % completed by 62 participants is 48%. 10 participants out of 62 completed 63%. my question is how much the remaining 52 participants complete? can we solve it using a formula in excel? its a simple logic...

Hi, I'm working on related item(s) countifs to populate information. However, I dont know if there is a easier way to show up information for the same thereby I planned to use index. Attached is the sheet with my criterian stated in i11 cell. I would be more than happy if there is an easier...

Hi, Since I've a large data to work with when I use the array formula its takes a while to generate information thereby if I wanted use vba to generate results for me. However, my code gets a debugging prompt. I'm trying to populate the results in column p with the following formula of excel...

Hi, Im using the following code to convert the number stored as text to number. However, I get out of memory run-time error 7. Am I doing something incorrect here? Range("A2:BZ65000").Select 'specify the range which suits your purpose With Selection Selection.NumberFormat = "General"...

Hi, In the sheet that I included it has 7 filter's and the formulas work if there are values against each of it. the idea is to help users to navigate to the specific list which would also mean that they need not choose all the 7 filters and should be able to show up all the unique values...

Hi, Attached is a sample data and I'm trying to pull data that match the criterias in highlighted cells to populate information for me in columns j through o. I can generate the values using a single criteria for levels and id however I dont know how to include multiple criteria to pick up...

Hi, I'm trying to use Countifs to count the occurence with multiple criterias matching using either countifs or Sumproduct. Attached is the sheet that I'm using for the same. The users get to choose values in column L (highlighted in Orange) and based on the selection the counts should be done...

Hi team, Attached is the sheet I'm working on presently. The basic idea is to update the risk sheet with dependencies data. Risk sheet will have a command button when clicked it would get the data in sheet3 (mirror data of dependency sheet if they are not already registered as risk). I've...

Dear Team, I've shared a sheet as an example. I would like to know how to create the following ranges of this sheet to powerpoint slide using vba? range1 = Sheetname(Table1).Range(a1:c4) Range2 = Sheetname(Table1).Range(F1:H4) Range3 = Sheetname(Table2).Range(a1:C4) Range4 =...

Hi, Probably this would be very simple but I'm not sure how to populate this one. There are two combobox in a sheet. The first combobox has a dropdown of named cells and the second combobox should list those named cells based on the user input in the first combobox. Not sure how to do this. I...

Not sure how to do this. Columns A B C D E F G H [Blank] [Blank] Header Months Date units update Comments The form should do this. 1. User should be able to select month from the drop-down (I've already placed content) 2. Based...

I'm not sure how to but this is what I intend to have, if my selection is LA msgbox should state "enter details", if my selection is CA msgbox should state "enter details", if my selection is "others" msgbox should state "please try again", if cell is blank there should not be a msgbox prompt...