Search results

Hi, Try a combination of if, not and count. If you want specific formulas for each column do let me know. I ll then post the exact formulas. Thanks

Hi, I want to maintain a log of files that were renamed or copied or moved to someother location, with their current and old location as well as timestamps. Further if possible those files which were sent as attachments in mails or were deleted should also be included in the log. Any help is...

Hi, I have a set of data which I want to rearrange in a particular format. The data is really huge. I have attached a sheet containing a sample of it. The sheet contains two sections - one with the sample data and the other with the format in which data is required. Please help me with this...

Hi Hui, That worked like magic. Thanks for the help. I have just started learning VBA and the power of coding amazes me everyday. Please help me with tips to learn the language faster and in depth. Thanks once again. :)

Sorry for not uploading the workbook. I understand it becomes easier with an example workbook. Will upload one everytime I ask a query in future. Thanks.

You can also google for websites that can help you with this.

Hi all, I have a sheet where there is data in column A. I want to sum few cells and display the result in a cell showing individual values as well. For eg - cell A3 is 200, A5 is 120, A10 is 180. I want the sum in cell B1(say) to be shown as =200+120+180. I will be filtering the values in...

Hi, I have written few lines of codes for specific purposes. The codes are working when I am directly using it in a workbook by inserting a module and pasting the code, however when I am saving the file as an add in, I am not able to use it. After creating the addin I have added a new ribbon tab...

Hi, I have a workbook with many sheets. The sheets are named as Purchase - Fund A, Purchase - Fund B...Sale - Fund A, Sale - Fund B and so on. When I am arranging the sheets, All Purchase sheets are coming first then all the sale sheets i.e. the sheets are arranged alphabetically. I want sheets...

I am using excel 2013. I created an addin for textjoin and that worked. Thank you. :)

Can you share the file?

I have an excel file where in column A I have few asset IDs, against each asset ID there are multiple Descriptions. I want all the descriptions to be in single cell with a line break in between each value. I used the concatenate function but that takes a lot of time, moreover I have to do a lot...

Use the formula =TEXT(RIGHT(C3,17),"hh") This will display only hours. I hope this helps.

Hi, I have used if statement along with and operator. The formula can be further simplified using named ranges and by restructuring your table. Refer the attached file.:) Best Regards, Pankaj

Hi, I am making a tool for tracking the performance of few stocks. I want the prices against the tickers to update automatically. The value of indices should also be updated. Once it is ready I will further develop it for my analysis purpose. I installed smart tags but that did not help. I also...

Thank you. :)

Thanks..this was a better way.:)

Hi, I have a drop down consisting of two items- Month and Quarter. When month is selected, list of months is to be displayed in the adjacent column and when quarter is selected, list of quarter should be displayed. I have defined both the lists in other columns which I will eventually hide. I...