Home

Excel

334 Conversations

Latest Activity

Custom List Message Item

MY EXCEL 2016 DO NOT SHOW ME MAP GRAPH SOMEONE KNOW WHAT IS THE POSSIBLE REASON FOR MY PROBLEM???

3,594 Views
36 Replies
I am having the same issue. This feature has been requested by one of our users. I downloaded the latest version I could from the Current channel (Version 1702 (Build 787... Read More

Mark,

 

You need this version

 

1611  Buid 7571.2075

 

Excel 2016 Version - Map Charts.PNG

Read More

EXCEL 2016 MAPS.PNGHello Everyone,

I have tried to represnt my data on map charts. however it does not show any maps. Rather it shows me bar charts or pie charts. How do i solve this problem? I am on a very tight schedule with my boss. . I have attached the screen shot view

... Read More
15 Views
0 Reply

Hi there, 

 

I am using the "Any Calendar Year (1 month per tab)" calendar template to create an event calendar. But I need it to run from July 2017 to July 2018, and i can't figure out how to add another sheet with the same calendar format or change the Ja

... Read More
13 Views
0 Reply

I have two columns of email addresses.  I want to identify (but not remove) any email addresses that are in both columns.  Any advice greatly appreciated!  Charles

62 Views
4 Replies

Hi @culm,

 

Is this ok for you

Hello

 

This is a frequently asked task and there are about 59 millions Google hits to choose from.

Hit #1.

Read More

Hello,
I have a question about Exel: can every type of text  become an X?
When I put a text, any type, I would like to trasform it in an X, is it possible?
Thank you.
Regards.
Antonio

53 Views
2 Replies

Hi Antonio,

 

If you want to show the text as X you may apply custom format to your cells as

#,##0.00;-#,##0.00;0;X

selecting most suitable for numbers part.

 

If the goal is t

... Read More

Hi @Antonio Castagnella

 

Using find and replace function

 

Give "?" in find, replace with "x".

 

Ask if you want anything than this.

Read More

Dear Sir,

ACCOR99KKK ACCORD98PQR BB498655I
CCO58965KK ACTIO3259LK9I FG99FGG5
ACCOR99KKK ACCORD98PQR FF559GGT
CCO58965KK ACTIO3259LK9I CDR56789
ACCOR99KKK ACCORD98PQR NJU999FFI
CCO58965KK ACTIO3259LK9 KKOI994F9

 

The above are 18 cells are in a worksheet, how do I

... Read More
52 Views
1 Reply

Hi biju1011

here is the vba code you can use for the purpose. This would colour red all characters of '9'. Please also see the attached file for an example, where you can
... Read More

I want to filter the following list in place where any of the 4 quartely columns contain the number 3.

 

Name     Q1     Q2     Q3     Q4

Peter       1        4        2        1

Lynn        2        1        3        4

Kevin       3        4        1        1

... Read More
36 Views
2 Replies

Hi

 

Insert a helper column ...

=COUNTIF(Table1[@[Q1]:[Q4]],3)>0

... and filter on TRUE.

 

Best Response

Good day!

I am trying to create a Staff directory list for my departments staff that are based in our school district of 190 schools.  I have created a data set with the schools and the staff positions of each school.  On the main page I have created a dro

... Read More
66 Views
1 Reply

Hi Christopher, 

 

So are you trying to have a drop down list that is dependent on the school selected?

 

If so you may find this article on dependent drop downs useful

 

https://www.linkedin.com/pulse/excel-dependent-drop-downs-wyn-hopkins

... Read More

Any assistance would be appreciated.

 

A1 = Date 1   (May 29, 2017)

A2 = Date 2  (Feb 22, 2010)

A3 = Date 3 (June 13, 2017)

A4 = Difference in total length of time between A3 - A1 (15 days)

 

Then, I want to calculate A5.

A5 = A4 + A2 (to calculate a new date)

 

I

... Read More
61 Views
1 Reply

Hello Joan

 

What is the problem?

You wrote it yourself, the result in A4 is 15 days.

And if you add 15 days to Feb 22, 2010 then you get Mar 03, 2010.

 

A4 is always measured

... Read More

the formula appears not the result. what's wrong?

41 Views
2 Replies
Hi @Bob Glemming, Check whether you put '=' sign before formula. If yes, press 'Ctrl+`' key which was found before number '1' Read More

Hi Bob,

 

please try the 'Ctrl+~' key combination.

 

Thank you

Yury

I have a list of 195 names in a single Excel column.

 

I want to name the tabs across the bottom of my Excel sheet with those names.  In other words, I want to auto name the 195 tabs without having to do them one at a time.

 

Any idea how to do this?

 

Thank yo

... Read More
45 Views
1 Reply

Hi Ronald,

 

You may do that with help of VBA code, google will give you quite many samples. One of them is https://support.microsoft.com/en-us/help/2790229/step-by-step-rename-excel-sheet-with-cell-contents-by-using-macro

Read More

Hello, I have a couple of Excel Trackers on a Drop Box shared drive. For some reason I cannot get them to be shared but only allow one user to edit at a time. Usually if someone is in edit mode on a shared spreadsheet another user will get a notification

... Read More
30 Views
0 Reply

Hi

While using 2013 Excel, I used to set number format list in Quick Access Toolbar as the 5th buttom, so that I can change data number format by alt+5, and push "g" to automatically select "general" format immediately. 

2017711-135246.jpg

But now in 2016 excel,  in this proc

... Read More
69 Views
3 Replies

Hi West,

 

In 2016 is the same - you may add Number Format as 5th or whatever button, press Alt+5, and you'll be on General format by default, just press Enter. Or you may

... Read More

I have a worksheet where I use pivot tables to sort data.  Each day a new tab is started using the move/copy function. The worksheet is updated and thats where the fun begins. Prior to July 5  I would go to analyse and change the date to correspond with t

... Read More
42 Views
0 Reply

We are using Office 365, connecting to files with a mixture of WebDav and Web Browser.

This "locked by another user" issue seems to pop up fairly often for us, most commonly with Excel files.

 

I've seen a lot of discussion around locked files on SharePoint,

... Read More
53 Views
0 Reply

Hi,

 

I have a formula that produces an array.  Once I click enter the cell says "resize to show all values". When I do this it prints the 30 value array in 30 cells.  However this spreadsheet is going to be rather large and have many cells like this.  I on

... Read More
57 Views
3 Replies

Just wrap the formula in =SUM() and press control+shift+enter.

Hi

I have an excel file with dates (month) from 01/07/2016 to 30/05/2017.

Excel is only filtering the top 4 months on the list. (everytime I sort the date, either from oldest to newest or vice versa) There are no spaces, I've removed and added the filter, c

... Read More
258 Views
13 Replies

There is a known issue in Excel 1706 with date filters not showing all the dates of the data in the column.

 

Currently, the only workaround is to roll back to Excel 1705,

... Read More

Hi

 

There is a limit.

Items displayed in filter drop-down lists

10,000

 

 

Read More

Hello all,

I am having issues trying to get an Excel templete to work properally, the templete is NodeXL basic when I try to access it to work with the templete I get the following error message when it tries to load:

 

************** Exception Text ********

... Read More
32 Views
0 Reply

Hello community

 

I'm trying to create and copy a formula to the selected cell in column C red if that cell value is 80% or lower than the cell next to it in column D. I tried this formula (=SUM($D2*0.81)>$D2), but I'm not really sure what I'm doing. I also

... Read More
68 Views
6 Replies

Hi Noel,

 

I guess the conditional formatting rule formula could be

=$C2<0.8*$D2

and the rule is applied to $C$2:$C$17 or to entire column $C:$C

 

Read More

I am trying to get a pie chart, or any chart, to show a percent complete.  In the example attached, I have gradient conditional formatting set to fill when the total count in 16.  I would like to make a chart out of this column to show a percent complete

... Read More
60 Views
5 Replies

Hi Taryn,

 

As an option you may show % in your Data Bar conditional formatting. Use for calculations COUNTA()/16, format W as %, and in formatting rule change Min and Max

... Read More

Hi John

 

Some possible solutions:

=56+E10*7
=LOOKUP(E10,{2;3;4},{70;77;84})
=CHOOSE(E10-1,70,77,84)
=SWITCH(E10,2,70,3,77,4,84)
=IFS(E10=2,70,E10=3,77,E10=4,84)
Read More

I have a workbook that suddenly has its structure protected. There is no password, but when I uncheck the 'Structure' box in the 'Protect workbook for' section of the 'Protect Structure and Windows' dialog, the OK button becomes greyed out - see image.

Why

... Read More
97 Views
10 Replies

Hi

 

The screenshot shows that your workbook is currently not protected because the dialog only appears when you are going to protect the workbook.

 

Read More

When protecting a workbook's structure you MUST enter a password. If there is no password, the structure is not protected.

 

See the support article for details on how prot

... Read More

I am using Office 2010 w. Windows 10. I want to format cells for TIME. I select Format cells, Time and then Type= 13:30.

 

Whatever I enter comes up as 1/11/1900 12:00:00.

 

I also tried to use Custom with Type=h:mm, same result.

 

Is this some kind of a known

... Read More
81 Views
3 Replies

steu wrote:

I am using Office 2010 w. Windows 10. I want to format cells for TIME. I select Format cells, Time and then Type= 13:30.

 

Whatever I enter comes up as 1/11/1900

... Read More

Hi @steu,

 

In my PC also, it shows year 1900, but time comes correctly.

 

Try "Ctrl + Shift + ;"

 

Then change to your custome time and apply format as you want.

Read More

Need to retain wkly readings while showing most current records in Month report. H7 IF formula OK for P7,Q7, but how do I (Nest?) IF statement for P7,Q7,R7,S7?

 

Thanks

57 Views
1 Reply

Hi

 

You want to retrieve the value of the rightmost cell.

=LOOKUP(9^9,P7:T7)

The search criteria has to be greater than any number in the search vector.

And 9^9 is the shorte

... Read More

Hello,

I am having trouble finding words in an excel worksheet. I tried multiple options with the Find & Select, but when I type in a name or words that I know are in the excel sheet, nothing shows up. 

After scrolling through the excel document and locatin

... Read More
81 Views
3 Replies

Hi

 

Is the text a result of a formula? Then klick on "Options" and change "Look in:" from "Formulas" to "Values".

excel-find-replace-select

Read More