Excel Questions & Answers - Microsoft Office

All Questions

Filter by

Polls Per Page:

Avarage formula
I have excell row containing 100 cells. First 20 rows have numbers then 50 cells are 0 again last 30 …
Ziya Explorer Asked on 8th February 2018 in Excel for Windows.
- 531 views
- 1 answers
- 0 votes
Macro shortcut insert column failure
Hi all, Hopefully this is a straightforward issue…. I have a macro which works fine when run via view macros …
lou2704 Explorer Asked on 18th October 2017 in Excel for Windows.
- 597 views
- 2 answers
- 0 votes
If I rate a list, can it be generated on a separate sheet in order of selection.
For example, if the item in A1 is ranked as 10 in C1, can the text in A1 appear in …
TheLonz Explorer Asked on 15th September 2017 in Excel for Mac.
- 818 views
- 1 answers
- 0 votes
Cannot use the sum function
Hi Guys, As you will see from the below attachment i cannot get the sum of my columns even though …
Elorourke Explorer Asked on 3rd July 2017 in Excel for Windows.
- 615 views
- 1 answers
- 0 votes
How do I create an auto prioritized table ?
Is it possible to create an auto priority column in a table list? Initially, I have a priority list column in …
Drop down list

List

Priority

Sorting

Tables

maxxis Explorer Asked on 19th March 2017 in Excel for Windows.
- 2K views
- 1 answers
- 0 votes
Finding best formula in Excel to count for my case
Hello. I cannot solve this mathematical problem: Let’s say I have 5 cells. Each of them represents one unique item to buy. …
COUNT

Formula

Ondrej Zeman Ozzy Explorer Asked on 25th December 2016 in Excel for Windows.
- 1K views
- 2 answers
- 0 votes
SUM / COUNT / SUMIF by cell color?
Hello All, How to use = SUM / COUNT / SUMIF by cell color? Some people said can use VBA …
Colour

COUNT

Sum

SUMIF

VBA

WingKaWong Explorer Asked on 1st October 2016 in Excel for Windows.
- 1K views
- 0 answers
- 0 votes
In my excel F4 key for repeat the previous function is not working
In my excel F4 key for repeat the previous function is not working. Thanks for your support
F4

Function Keys

Support

Madhu Enthusiast Asked on 1st October 2016 in Excel for Windows.
- 3K views
- 2 answers
- 0 votes
How to split the content of a cell?
Hi I need to split the content of a cell into one column and auto insert multiple rows depending on …
Insert rows

Macro

Split cell

ahmadroz Explorer Asked on 25th June 2016 in Excel for Windows.
- 1K views
- 0 answers
- 0 votes
How to insert multiple blank rows?
Hello I need to now how to insert multiple blank rows with macro between many rows for example Insert 5 …
Insert rows

Macro

Rows

VBA

ahmadroz Explorer Asked on 25th June 2016 in Excel for Windows.
- 1K views
- 0 answers
- 0 votes