I want to pull certain keywords from a sentence basis some list of keywords.
For e.g. Cell A3 has a sentence: "Sumit has consulting experience". Cell B3 should return Consulting. Similarly in other rows there would be different sentences with different keywords, and separate sheet would have...
Hi,
I want to pull the names of all the entries where the data is less than equal to 3, with this formula it should return all the entries even if there are any duplicate entries.
Details are in the attached spreadsheet.
Regards,
Manish
Thanks Rollis, this is working fine.. but what should be done if the range contains formula. And there should be no Message Box, when all the conditions are matching.
Hi,
I want to include some Pop Up Message, if numbers in the cell doesn't matches some predefined criteria.
Details are in the attached spreadsheet.
Regards,
Manish
One more thing, the code is copying the exact data from column A, hence if there is any formula to calculate values in column A, the code is copying the formula as well, which is resulting in error. The code should only copy the values from the column A
Regards,
Manish
Hi Rolli13,
The macro is working perfectly fine, however there is just one issue with the code. The code should only copy the cells where there are values, and the code should stop the moment it finds a blank cell. For e.g. in the spreadsheet, I have data till A10, hence it should copy the...
Hi,
I want to write a macro so that, It will pick the vales from the range A3 to A21 one by one, and then paste it in the Calculation Tab (Cell C3), when and copy the output from cell C6 (Calculation Tab), and paste the same in the range B3 to B21 of the Opportunity Tab.
First the formula...
Hi,
I have a report wherein the chart range always varies, sometime we have less entries, sometimes there are more entries.
However I want to have a dynamic chart which will have the range selected for the entire range. Hence the chart will be created only for the cells where we have the data...
Thanks Vletm, It worked with the suggestions you provided. Each data point in column C is dependent on the value from column B, hence we have different values. Will remove the extra character
Hi,
I have a macro code to color the bars as per entries in column C.
Legends or colors for each entries are mentioned in range G1 to G3.
The code works perfectly fine if all cells in column B and C have data, but the moment we have blank cell either in column B or C, the code does not work...
Hi,
I am looking for a way to repeat the occurrence of a text with condition in another worksheet. Details are in the attached spreadsheet.
Regards,
Manish
Luke, I tried that, but it was not working.
Attached here is the latest attachment, wherein I want that code, column is highlighted in yellow in Data Flat File tab.
Additionally, the table wherein I need to write up this code is derived from Power Query, hence when I am trying to write a simple code to see if that is working in that table. I am getting an error. I have attached the screenshot of the error.
Regards,
Manish
Thanks Luke,
The formula works perfectly fine, but its not working If i want to add any conditions.
Example is in the attached spreadsheet.
FYI, the formula I am trying to use have multiple conditions and formula is to pull values from a database.
Regards,
Manish
Hi,
I am looking for a code to copy formula from first row to the cells below and after pasting the formula, the all the cells below should have paste special values only, and the formula should not be visible, but the formula should be retained in the first cell from where the formula was...
Hi,
I want to calculate dynamic average from a range of cell. For e.g. If I select 1 from a drop down, it should show the data for the latest period only, and I select 2 from the dropdown, it should calculate the average of the latest year, and the prior year data. If I select 3 from the...