Home

Excel

500 Conversations

Latest Activity

Custom List Message Item

Hello!

 

I was trying to delete many connections at the same time at "Data<Queries & Connections" tab, but when i click to open the "Connection" tab, i just cant select as many as i want do delete. Before it was easily because in the "Data" tab there was on

... Read More
51 Views
2 Replies
I'm afraid there is no way through the user interface. May I suggest to add a suggestion at http://excel.uservoice.com ? Read More

I am using the following successfully to validate a form combo box [using the "RowSource" parameter] against a table on a work sheet with a single column :-

LookupData!Table_Query_from_harglive9

Does anybody know how to alter this to specify a specific colu

... Read More
42 Views
3 Replies
Generally speaking using the RowSource to fill a combobox on a userform is frowned upon. I always write the data to the combobox using the List property directly, e.g.:
Co... Read More
Best Response

Since yesterday (September 18, 2017), my financial report downloads (CSV files) have not worked properly.  Opening the downloaded file results in all the data appearing in a single cell (A1), in "mumbo jumbo" text form.  The alert about "preserving featur

... Read More
22 Views
2 Replies

Yes, that's not an Excel issue, it looks like the routine which export csv file doesn't perform HTML/XML decoding.

 

If take beginning of your file

 

Category&#x25;2CSymbol&#
... Read More

Hi,

 

I suggest to compare the CSV file (you have uploaded here) with a CSV file, which previously worked. For comparing, open both in a text editor (such as Notepad) and n

... Read More

I need the old style Pivottable formatting as explained in the below url but when I apply a custom pivot table style to it the grouped gridlines disappear so is it possible to have the best of both worlds.

http://blog.contextures.com/archives/2010/05/14/pivot-table-formatting-old-style/

... Read More
12 Views
0 Reply

I have to sign in and out on a Log Sheet using hours and minutes.  What I need someone to how to enter this on an excel speadsheet so at the end of the day it will calculate time work. How will I do this?

 

24 Views
1 Reply

Hello,

 

if cell A1 has the start time and cell B1 has the end time, you can calculate the elapsed time by subtracting A1 from B1.

 

=B1-A1

 

Format the result as time. If you

... Read More

Hello,

 

We are new to this community, but not without experience in excel.

 

Our club has recently done a survey of our members, and we are trying to find when people are available and which of our activities most interest them. to do this, we are trying to

... Read More
48 Views
4 Replies

When one more variant with keeping asterisks as it is, the only point to correct misprint Satuday* -> Saturday*. 

=SUMPRODUCT(
   (ISNUMBER(SEARCH(LEFT(F$32,LEN(F$32)-1),O
... Read More
Hello:
The problem that you are having is that you are looking for the days of the week within a string. Therefore, a potential solution is to put an asterisk (*) also at ... Read More

Hi there,

This is my first post for asking for help.  I have a spreadsheet that we use to record our outbound mail information, so it doesn't process any numbers or anything, it's merely just a record table.  It is separated into 12 worksheets - one for ea

... Read More
124 Views
6 Replies

Hello,

 

it's a bit hard to visualize what you want to achieve. Can you attach a simplified example with non-confidential data? Just a few rows will be enough. Then explain

... Read More

Hi,

 

I am new to the group and very much a novice.  I have searched the web looking of a macro, code or function to add a drop down calender for excel 2016 64 bit.  Is there a way to add this process?   Thank you in advance for your help!

Read More
47 Views
1 Reply

Hi Tom,

 

For my knowledge Microsoft has no in-box solution for 64bit version (as data picker for 32 bit). However, google could show you third-party solutions like this on

... Read More

When I'm in Excel, select F1 to bring up the help column on the side, and the select a subject, I get a drop down menu of sub-topics to choose from.  I select a sub-topic and click it, but the help never goes any further.  I don't get any info about the t

... Read More
377 Views
32 Replies

Hi Scott,

 

What version of Excel are you using? You can go to File > Account to check.

 

Is this the Help pane you see:

 

Excel_HelpPane_Intro.png

And if so, you're not able to get past that? O

... Read More

Hi all, 

 

I am having difficulty putting two logic together, that is  have a formula that works to return the data from 2 criteria using simple Match logic, BUT having difficulty using multiple return values in row logic with it. 

 

This is where I have got.

... Read More
36 Views
1 Reply

Hi Sarah,

 

It looks like you incorrectly check second criteria. There are few approaches to extract rows from the list based on multiple criteria, e.g.

https://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/

https://www.get-digital-help.com/2010/02/11/match-two-criteria-and-return-multiple-rows-in-excel/

... Read More

Hi, 

I'm having an issue with the "My Cash Flow" Template

The application cannot be edited. So I can't add my data.

The instructions for adding "Power Pivot" Don't work and/or are incompatable with Excel 2016 Home and office.

Is anyone else having this proble

... Read More
40 Views
1 Reply

Hi Thomas,

 

I guess you mean this Learn how to use the My Cashflow template with Excel 2016 template. Yes, Power Pivot is available only for Enterprize subscriptions of O3

... Read More

Hello everybody!

 

I need to notice when the date of a planned event is past but it is written in the column B (status) that this event has not been realized (it means that a planned event has not been organized as planned)

 

Thus, I try to apply a conditiona

... Read More
104 Views
8 Replies
Bonjour Clemence:
if you can send just part of the worksheet and clearly explain your goal, I can send you a vba code with an if statement that will help you.
J'ai tente de... Read More

Hi Clemence,

 I guess AUJOURDHUI means TODAY in English. With your sample you may apply the rule 

=($A25>TODAY())*($B25="Non")

on region

=$A$25:$B$34

as in attached

Read More

I have a column that shows time in hours as example of

19.77

2.04

0

0.19

69.06

0.03

0.92

9.32

 

If I format the column as time format h:mm the time typically converts, but there is some that will not convert at all.

This works 19.77 turns to 20:

... Read More
225 Views
13 Replies

Hi Mike,

 

I'm not sure how you receive such results, if you attach small sample it'll be more clear. You have some numbers in your CSV file, let take 19.77. In Excel integ

... Read More

Hallo all i need help and dont know wath to do.

If i Import somthing from the in Excel i kan not use it. I can not add the Numbers ore do anithing witz it i have allways the same bug. #value! in germen #wert! 

Do you know wath i do wrang ? 

 

I Just want to a

... Read More
148 Views
11 Replies

Hi Manuel,

 

I guess, you imported the data from a text file or a CSV file? It looks like that the values have been imported as text ($ 123...). Therefore, when adding the

... Read More

I am an IT technician and I have been tracking your work for some time, I have a client that is trying to use an Excel 2010 feature but I can not help because this button is not active, how could I activate it?

 

Or is this feature EXCLUSIVE from Excel 2016

... Read More
45 Views
2 Replies

The Forecast feature was introduced in Excel 2016, so it's not available in Excel 2010. See: Create a forecast in Excel 2016.

 

If you do have it, but it's not enabled, t

... Read More

Hi Sandro,

 

I'm almost sure that's for 2016, as well as FORECAST.ETS it uses. You may check support pages for them to check to which versions they apply to.

Read More

Hi All,

 

I am trying to build a new report on top of my existing(already present in one of the sheets in excel) data. The existing(source) data looks like below:

Source Data.JPG

 

I would want the output to look like below :

 Output.JPG

 

I would need to build drop down filters to filte

... Read More
39 Views
1 Reply

It sounds like you want dependent Data Validation.

 

Regarding outputting to a new sheet, you could select all, then Go to (F5) > Special > Visible cells only > Copy/Past

... Read More

I have grown tired of having to configure pivot tables how I want them every time they are created.  I was pleased to hear about a new(ish) feature that allows you to set the default for all pivots you create.  

 

I followed this guide: https://support.office.com/en-us/article/Set-PivotTable-default-layout-options-efd8569c-f07a-43c1-9db2-4f2912a0f94e

... Read More
119 Views
13 Replies

Hi Euan,

 

This functionality was introduced in May this year for Office 365 subscribers in the build 8067.2115 (Current Channel).

 

It is unavailable if you are on another v

... Read More

Is there a way I can shade a cell, but keep that cell from being shaded when I print the sheet? For example, I want someone to enter data only in the cells I've shaded yellow, but I want the finished print to not have yellow, shaded cells.

88 Views
3 Replies

Hi @Joel Lee,

 

Go to Page Setup -> Sheet Tab -> Enable Checkbox Black and White

 

Untitled4.png

Read More

Hola a todos, necesito algo de ayuda. Estoy haciendo un informe utilizando mapas 3d, no puedo hacer que muestre Tierra del fuego, en su lugar me muestra el sector bajo de Chile. como puedo hacer??

24 Views
0 Reply

I am using the following successfully to validate a form combo box [using the "RowSource" parameter] against a table on a work sheet with a single column :-

 

LookupData!Table_Query_from_harglive9

 

Does anybody know how to alter this to spe

... Read More
19 Views
0 Reply

I'm trying to avoid entering the slashes during data entry. I want the date formated mm/dd/yyyy. Is it possible to simply enter mmddyyyy and have it auto format to the date format above?

35 Views
1 Reply

Yes, choose the Format Cells command, select Custom from the Category listbox, and type ##"/"##"/"#### into the Type textbox.  

Hello,
I have a WS with autofilter in the headder. The WS contains 2 columns of formulas, the rest is supposed to be a Register filled up by unqualified personnel, so I have to protect the sheet for the safety of 2 columns in the middle.

The first columns i

... Read More
69 Views
7 Replies

Hi Natalia,

 

1) On unprotected sheet unlock the cells you'd like to allow to sort - select them, Ctrl+1 and

 

Unlock.JPG

2)  Select proper options while protecting the sheet

Sort.JPG

 

Read More

 

Capture.JPGIn my table for work I have a column with duty number shown in Column A in the image.

 

In the blank cells of Column A I want them to be filled with whatever the cell above contains but with the suffix 'A' so column A will read:

1051

1051A

1052

1052A........

 

I

... Read More
36 Views
1 Reply

Simon,

 

select column A.

Press F5.

Click on "Special ...".

Select "Blanks".

Click on "OK".

Type = (equal sign), press CURSOR UP, type &"A".

The formula should read =A2&"A".

Press

... Read More

Good Day! I am far from a knowledgeable person when it comes to Macros or VBA codes, but I am learning. Currently, I am in desperate need to write some VBA code for a spreadsheet that is used by my workgroup.

 

This is the process: One dedicated person ente

... Read More
51 Views
1 Reply

I have solved my own issue! I have found the correct VBA code on another website. Thank you for your views. 

Hello,

I need to combine multiple data sets with different column headings in order to create a pivot table.

I have found power querry and it works with a few of the tables. I have created tables that pull information from sets of data. They all have blank

... Read More
32 Views
1 Reply
Possibly some hidden characters in some of the cells. I usually have to fight with CHAR(0160). Its a little front end work to validate the data and see if any cells are p... Read More