Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
Articles & Videos
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and anything else related to the spreadsheet user interface, including error messages.
I have got a worksheet full of data (around 2000 rows and 15 columns). I need to do a sumif to see how often in the data, 2 columns match, to see how many rows have those same 2 values in these 2 colu…
I want to know the formula for :
if i have 10 days and my start date is 26/09/2016 i want to know how many days i am in for 10 days considering weekend.
so 10days starts from 26/09/2016, on …
I am trying to match 2 lists in excel to find unique values. One list has data after the data I am trying to match and I am having an issue trying to add a wildcard "*" to the data. I have tried a con…
HI Experts using excel 2010
I am using the Ctrl F to find data text absolute value ok but when the cell is linked to another cell via = sign is does not find it..
What's the work around.
Hello Expert Exchange helpers and users. I have this code that labels the task with a number, so that it may show me what is the order all the task, i would like to add an additional rule to have it d…
I have a spreadsheet I create from a subset of another one with a VBA routine. The spreadsheet is getting 2 extra pages at the end of it in print preview mode that I can't explain. Anyone hav…
I am using Excel 2013. I have a very simple .xls worksheet which records our vehicle inventory, it is over 1000+ records. The columns are:
Make; Model; Year; Licence_Num; State_Registered…
I created a share and mapped two users with modify permissions. I am having issues with an excel 2013 file that keeps saying it is read only. I have removed the read only permissions from the file in …
I have some Data/Time fields in a table in Access, where I have set it to Required = No.
When I fire off an INSERT (via ADO) to insert data it doesn't like it if there is no Date. ie. Blank.
I have to record the mileage each month for company vehicles.
I would like to have a running total of the mileage.
Sept Oct Nov Dec Runnin…
Hi Experts using excel 2010
I havethe following if formula...
Which should when the previous date is the sam…
In the attached file, if I try to add up the times using Autosum (A36) I get 0. If I add them up using +, (B2), I can add them up...anyone got any ideas as to what this might be?
Kindly help me plz
i need to change color of next cell
A B C D E F G
2 5 5 5
3 2 5 3
4 5 5 5
5 4 1 0
Let suppose upper mentioned values are Data and i need to change colo…
Let me describe my Excel workbook.
Sheet1 = a drop-down box to select a country.
Sheet2 = a list of countries with address and other details.
Sheet3 = A place to display the correctly …
Is it possible to digitally sign an Excel document? So for example if an invoice is created in Excel can someone with a touch screen sign it off?
I want to copy also the row height, from row 1 to row 6, by these codes
(CODE)If you see the attached Excel file, some rows is having short height. How to ensure the above to achieve what I expect…
Points of My Scenario
1. I have a spreadsheet with 2 (two) columns, A and B
2. I need to generate a column, C, that has alternating values/rows of columns A and B
Point of Clarification: If columns…
i need help, is there possibility to create named range where it only encompasses the visible cells only?
I need some VBASCRIPT that will scan an IPv4 address in column A of an Excel Spreadsheet and output the mac-address in column b, the name of the device in column c, and whether it is IPv6 compliant in…
First Tab - Master customer data file. Tab Name = "MASTER"
Second Tab - specific data for an individual customer. Tab Name = "13 n clark"
Goal: How do you automatically populate the 2nd tab from …
I am trying to transfer my DNS records to Dynect. They only support BIND and tinyDNS formats to upload the records to them. My current hosting parting cannot export our records in either …
I am trying to use the sql management studio import wizard to import some tables from excel.
I have SQL server express 2016 installed and Excel 2016 (e3) (see image of version below).
Experts, how would I format the 'Date Entry'!D23 to date format?
="for the period between " &'Date Entry'!D23 & "and " &'Date Entry'!E23
the output is like so:
for the period between 42542an…
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 …
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…
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
33,636 points this week
24,636 points this week
Wayne Taylor (webtubbs)
15,000 points this week
crystal (strive4peace) - Microsoft MVP, Access
14,307 points this week
14,278 points this week