MS Excel

128K

Solutions

178

Articles & Videos

33K

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

Hi,
I would like to find a formula to convert ranked data to a fixed variable range  5  to  -5
Please refer to attachment
Many Thanks
Ian

20 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

Hello,

What is the best/simplest way to create an image of selected content from Excel or Word with a transparent background?

For example, suppose you have a table of values in Excel (or a coupl…

43 views

I'm working to incorporate several formulas that are presently in a very complex WB that has several hundred "Range Names".  Here is the question:

1.) I can drop and drag "Modules" to my new WB, bu…

90 views

We are trying to calculate a specific character that may repeat it self within a Excel.

For example:

We want the last "\" of the following string:

C:\temp\folder1\contents

We want the posi…

712 views

Hi All - Is it possible to hide all the toolbars in Excel 2016 the way Excel 2003 did to make things look more like a program?  My coding doesn't seem to do anything on E2016.

Thanks!!

714 views

Does any one knows what is gantt chart? and how to create them.

29 views

Hi, I have a simple formula in a cell.

Weeknum(A2)

When (IF) the value returned is an even number, I want the result returned to be +1.

In other words if the Weeknum returned is 2, I want to…

48 views

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you…

04,926 views

There is often more than one way to accomplish a particular coding task and one of the criteria that can be used to determine which method to use is to determine which one is the fastest.  But how do …

25,340 views

hi, i wrote this little bit of code myself. i think if you look at it you'll see what i'm trying to achieve... onOpen, set value of I1 to No


(CODE)

it runs through the script ok without error …

1435 views
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Hi experts,

I'm using excel. My spreadsheet looks like this:



So if you notice cells D1, E1,F1 and G1

This is just a sample spreadsheet. In my actual spreadsheet I have like 300 columns.

24 views

I have a reasonably complicated Excel 2013 spreadsheet used each month for various calculations.  The spreadsheet contains a number of Pivot Tables whose source is a Table that pulls data directly fro…

1018 views

I installed the plug-in MySQL for Excel, and after that default saving changed to .xlsx, so each time I had to change back to .xlsm

But when I tried to open that .xlsm file, it didn't work, I got …

311 views

Hello,

I have a list of macros in an excel file (also have them in a .bat file)
When I open excel, I want these macros to open as well so I can use them.

I know I can add the excel file to the…

421 views

Dear Experts:

for the selected cells in a column (contiguous range) I would like to perform the following VBA Action.

If the macro hits a cell (of this selected range) which starts with a numbe…

210 views

I have a set of 20 Excel files that need to have information redacted from them.  For the purpose of redaction, I just need to change the background and text to black.

For each row in my worksheet,…

1729 views

Hi,

Below is the table i am working with. i 'd like to populate data in cell c1, c2, c3, c4 based on a criteria. For example: If the criteria is 4 i want cells C1,C2,C3,C4 to display 70,80,90,100 r…

213 views

Dear Experts:

I got thousands of records where I have to concatenate two cells as follows

The Formula in D5 is as follows:
IF(C5="";"";C5&"_"&MOD($E$4;1;3))

Copying it down all the way does…

314 views

Hi,

Below is the table i am working with. i 'd like to populate data in cell c1, c2, c3, c4 based on a criteria. For example: If the criteria is 4 i want cells C1,C2,C3,C4 to display 11,23,304,40 r…

617 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Excel: Can I make a dropdown list that removes the dropdown's selected values from the dropdown list in future iterations & builds a list of previously used values?

List named "USERS" originally co…

448 views

I have a query that when I run it producing the attached error.   I am not sure what it is saying, I am exporting the results of the query to a Excel Spreadsheet with the following:

Private Sub Com…

732 views

I would like to modify the attached spreadsheet.
I would like a script to look into each field which contains the UPC code, and compare Year 1 to Year 2 to Year 3.
If some UPC codes are not shown in…

1543 views

I would like to sort through the Data in Sheet 1, and produce the output shown in Sheet 2.
I will add much more data to Sheet 1, perhaps over 600 rows and perhaps it may grow.
Can someone help me ei…

821 views

I can copy entire cells like this - values, formats, everything.

(CODE)

I want to copy only the Formats, Conditional Formats. How do I amend the above please?

Thanks

Edit: I want to avoid …

717 views

I see that {Numlock} toggles the Number lock.

I'm looking for a reliable way to ensure that, after my Sendkeys {Down} which sometimes leaves Number Lock state as 'off', to ensure that it is returne…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Office
    (57,065)
  2. Visual Basic Classic
    (163,556)
  3. VB Script
    (36,269)
  4. MS Applications
    (43,147)
  5. Spreadsheets
    (5,982)
  6. MS Access
    (215,524)
  7. VBA
    (5,122)
  8. MS Word
    (26,941)
  9. Programming
    (51,874)
  10. Visual Basic.NET
    (91,860)