MS Excel

127K

Solutions

174

Articles & Videos

32K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and anything else related to the spreadsheet user interface, including error messages.

Refine results

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…

50 views
Looking for New Ways to Advertise?

Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

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 …

60 views

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…

1127 views

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.

30 views

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…

29 views

Hi,

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…

40 views

Hi,

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…

919 views

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 …

30 views

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.
In my…

78 views

IF(
AND(COUNTIF($AP2,"*11*","*15*","*17*","*20*","*49*","*50*", "*71*", "*72*"                                                                                                                         …

50 views
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

I have to record the mileage each month for company vehicles.
I would like to have a running total of the mileage.

Example:
                  Sept       Oct        Nov        Dec           Runnin…

350 views

Hi Experts using excel 2010

I havethe following if formula...

IF(BB19=BA19,0,IF(BC19=BB19,0,IF(BD19=BC19,0,IF(BE19=BD19,0,IF(BF19=BE19,0,1)))))
 
Which should when the previous date is the sam…

717 views

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?

49 views

Hi
Kindly help me plz
i need to change color of next cell

  A B C D E F G
1
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…

522 views

Hi all,

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 …

311 views

Hi

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?

220 views

Hi,
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…

2770 views

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…

213 views

Hello,

i need help, is there possibility to create named range where it only encompasses the visible cells only?

thanks.

1317 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

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…

721 views

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 …

1453 views

Hi All,

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 …

38 views

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).

Everytime …

1152 views

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…

211 views

Hello guys i am trying to find out if this is possible, thanks again for your time and help.

On the "J" column have the Letter (Q) display no more than five times with the color of BLUE if on colum…

819 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Office
    (56,856)
  2. Visual Basic Classic
    (163,439)
  3. VB Script
    (36,160)
  4. MS Applications
    (43,118)
  5. Spreadsheets
    (5,953)
  6. MS Access
    (214,925)
  7. MS Word
    (26,844)
  8. VBA
    (4,635)
  9. Programming
    (51,762)
  10. Visual Basic.NET
    (91,593)