Articles & Videos
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
I would import the file into Excel, and it could have three columns:
i have this formula, the A1 contains another formula which results to some percentage value.
how can the below formula be simplified?
I am trying to save to an excel file, information from a view in lotus notes. I have already created the excel template and just place the information I want in the correct cells. All this …
I need a formula that will extract the MIN of the Opening Balance as fond in row 2 but for 5 days date range after the expense as shown in row 11.
I have uploaded a sample.
Hi, Please Please help, I'm stuck and frustrated by what must be a simple thing to overcome! I thought Mr Google has the answer to everything, but today he's falling short!
I'm nearly finished …
so i have a list of names in column A
in columns B-BG i have all the corresponding companies for these people.
I need to basically make a new 1:1 relationship for each person and each company. …
I need to add a rectangle inside a chart and actually make it a part of this chart.
I'm doing this because I need to display this rectangle in an image box, and the only way to do so…
hello Excel experts, I am trying, for an attendance sheet, to find the value for the second time of Peter (16:26:03), without any success. The first time of 08:32:00 has been found by …
Dear sir , i have a code, where it contains data , i need last updated time in a cell , so i have a formula, where it extracts date and time like this 23-FEB-2017 15:30:29 in one cell , but i need …
1. What is the best way to re-number column No (A) from 1 to visible rows please
2. e.g if I apply filter on Group1 with Yes rows. As it is now. in the sample file attached.
3. How to make…
I set up am excel macro to pull in a spreadsheet of line item PO's and then it formats for our shipping system. Im able to pull in the worksheet, name ranges etc. The problem Im having is naming …
could you help with attached sample excel and how to achieve this please?
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group…
Curious if someone has a macro that will capture and notate ALL changes made to a workbook and then email out out those changes made to an email address or distribution list? For …
Does anyone know how to run PROPER (Propercase) on an entire Worksheet in Excel (Does ALL columns)?
I found the below code and it works, but it adds extra space to the column height. How can I remove the extra space?
I am attempting unsuccessfully to format data in Excel as a table from Access. I was hoping someone could tell me what I'm doing wrong:
I have data in a spreadsheet that is exported from a guest Wi-Fi system. Users are required to enter a name and email address, or use a social media account to use the free Wi-Fi. That …
I'm struggling to hide a range of columns in another worksheet. The closest I've got is this code but that only hides them on the sheet I'm on:
Private Sub Test2()
Dim sws As Worksheet, dws As …
I have an Excel 2007 workbook with macros in it. When I open the workbook I get the following prompt.
What I can't understand is the second message asking about links to another workbook …
I cannot unhide columns, D, E, F, to the attached file. Why?
I have a csv file that only has data in column A. I have an excel workbook that I copy column A from the CSV to this excel workbook that I use to populate a mailing list. Problem is right now I am …
Within the enclosed sample spreadsheet I have 3 records. I'd like to find the average call time but not sure how.
Thanks for your efforts.
I am using the code
It removes some lines, but not all dups.
For instance GR 3 12x9x6 has (2) rows. Based on the code, there should only be (1) row.
It should remove anything that is the …
I have a column in an EXCEL spreadsheet made up of a date and time in the following format - m/d/time HH:MM. For example, 1/1/2017 18:24. I'd like to separate this into two cells. …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you…
by Patrick G. Matthews Introduction VLOOKUP is a tremendously useful function that allows you to "fetch" data from a specified rectangular range (the "lookup table"); this …
Walvis Bay, Erongo, Namibia
45,732 points this week
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
19,188 points this week
14,258 points this week
8,108 points this week
8,008 points this week