Home

Excel

761 Conversations

Latest Activity

Custom List Message Item

I have a spreadsheet that several people use and would like to keep the text in a particular column always set to upper case.  Regardless of case the user enters the data in this column it is saved in upper case.  Is this possible?  Thank you for your inp

... Read More
5 Views
0 Reply

Hi,

I have a problem sorting by date, i tried the Cell Format thing and also the Text to Columns to identify cells as Date cells , but nothing worked still cells are sorted incorrectly.

 

Anyone can help and tell me how it gonna work?

 

FYI, 

Excel.png

Read More
11 Views
0 Reply

Hi,

I have a problem sorting by date, i tried the Cell Format thing and also the Text to Columns to identify cells as Date cells , but nothing worked still cells are sorted incorrectly.

 

Anyone can help and tell me how it gonna work?

 

FYI, 

Excel.png

Read More
5 Views
0 Reply

Good day,

I'm a beginner, sorry for posting such a question, I've been trying to find a solution for a couple of hours, with no luck :(

 

I input values (prices) in B column, and in D column I assign categories (selected from a list).

In other tab I would

... Read More
15 Views
0 Reply

I have an Excel spreadsheet containing e-mail addresses. How can I stop my e-mail program (Thunderbird) composing an e-mail when I click on a cell?

31 Views
4 Replies

Kenneth,

 

Highlight the cells that contain hyperlinks, then right-click, and select Remove Hyperlink as shown in the below screenshot:

 

Remove Hyperlinks.png

 

To prevent that behavior from

... Read More
hi every one.. before 30-6-1977 rate was 15%, between 01-07-1977 to 30-06-1991 rate is 10%, between 01-7_1991 to 30-6-1993 rate was 5%, and after 30-6-1993 rate is 0%. Can any body share thoughts on this problem
21 Views
1 Reply

Hi Munib,

 

If the problem is to find the rate for the given date when that could be like

=LOOKUP(A1,{1,28306,33419,34150},{0.15,0.1,0.05,0})

where the date is in A1. Tha

... Read More

We can groups values by date in Pivot table. So I use it to group data by 7 days so that I get the sum of the entire week. 

 

But if I group the data I'd like to view the individual data for each day as well, which is not possible using "Groups" in the pi

... Read More
17 Views
1 Reply

As variant to add one more column to the table as weeknum and when to pivot using both it and the date.

Is it possible to have an input form for a single cell?

 

So what my requirement is that I need to collect the number of hours that we've worked on a project. I need a sum of all the hours spent by my co-workers separately in different cells. But I want t

... Read More
38 Views
3 Replies
I would enter each type of work as a separate row or have a tabe which has a separate column for each type of work so you can add them.

I work in french - I am - with an AZERTY board.

Today, as working on Excell, tne words I Wrote were with QS.. letters.

Only on Excell, not on Word or inthe mails.

How can I make Excell write back again like my AZERTY board ?

Thanks.

Martial

Read More
17 Views
0 Reply

Recurring problem on several computers on several versions of MS Excel. Latest is version 2016. I often times get an extra full-screen blank excel. It's completely a blank frame not a blank sheet.

 

It interferes especially when trying to type formulas. I c

... Read More
103 Views
1 Reply

Hi,

 

My use case is pretty easy I think. I am however unable to fully pull it of. Here's the setup:

 

  1. I have 1 big Excel-workbook that contains a lot of HR-data. This workbook will be refreshing daily and is stored in a simple documentlibrary on a Share
... Read More
22 Views
0 Reply

Is there a way to filter data in a spread sheet and then add it to another spread sheet, aside from copying and pasting? I imported data from another spread sheet, but I need to filter it and add parts to another spread sheet. I want to know if there is a

... Read More
46 Views
3 Replies

I have a Workbook with several sheet.  One sheet has data listed in columns, such as:

Class, Instructor, Type, Classroom, Day, Time Period

The Type, Classroom, Day, and Time Period Columns are drop down lists.  The Class and Instructor column are manually e

... Read More
160 Views
9 Replies

Hi Douglas,

 

please find attached my suggested solution. I have done the following steps:

 

1. Replaced the formula in I2 (lookup string) with '=E2&"|"&F2&"|"&G2'

 

2. Removed

... Read More

I began working on a spreadsheet via Office 365 last night, returned to it this AM and got a message which reads 'this document is locked for editing' -so new/additional information could not be saved unless I saved the sheet under a new name.

 

This is N

... Read More
26 Views
0 Reply

I'm trying to take a three digit number i.e. 123 and split it into three pairs; a front pair, a back pair and the outer two numbers form the three pair i.e. 12, 23, 13. I'm having trouble with formula. I tried to copy and past Google Sheets formula 

=join

... Read More
43 Views
2 Replies

Hi,

 

You got that error because there is no function in Excel called: JOIN.

 

Replace this:

=join(", ",{left(C3,2)&"x","x"&right(C3,2),"x"&left(C3,1)&right(C3,1)})

With

... Read More

Hi Alana,

 

Google Sheets formula not necessary work in Excel, these are different products. Your formula in Excel looks like

=LEFT(C3,2) & "," & RIGHT(C3,2) & "," & LEFT
... Read More

Hi,

I have the Data Analysis pack add-in and solver add-in in my Excel 2016. However, I could not find the tab where i can see the "Shopping Basket Analysis" as shown in the microsoft website (https://msdn.microsoft.com/en-us/library/dn282369(v=sql.120).aspx

... Read More
19 Views
1 Reply

That's not a part of Excel 2016. You may click around you link, that's somewhere with Data Mining Add-Ins for Office which work with SQL Server 2010 or so. Not sure if th

... Read More

Hi,

 

I am trying to set my default Pivot Table formatting as can be seen in the support article here:

https://support.office.com/en-gb/article/Set-PivotTable-default-layout-options-efd8569c-f07a-43c1-9db2-4f2912a0f94e

 

I have the same issue as can be se

... Read More
21 Views
1 Reply

Hi,

 

Set PivotTable default layout is only available for Office 365 subscribers, it came to Excel with April 2017 updates for Office 365 thanks to Bill Jelen (Mr. Excel)

... Read More

want to sort Japanese words ( Kanji) like sort feature in excel. I have tried many ways to sort Japanese text in PHP but the result is not 100% like result in excel.

First . I tried to convert Kanji to Katakana by using this lib (https://osdn.net/projects/igo-php/

... Read More
17 Views
0 Reply

Hi there,


I'm an excel novice and can only do simple formulas!  

I'm having difficulty doing a formula which is essentially:

 

If the cell A1 is R/O put 0.00 in, if it is B&B multiply cell A2 by £8.08.

 

Not sure if it should be an IF formula is there is a

... Read More
40 Views
2 Replies

Hi Katy,

This is the formula:

=IF(A1="R/O",0,IF(A1="B&B",A2*8.08,"N/A")) 

 

Of course, you can have a calculation inside IF function, not just a single calculation, as many calculations as you like!

 

Try this:

 

=IF(A1="R/O",0,A2*8.08)

 

Read More

Hi all,

 

I have a 'basic' file where I enter a product reference in the 1st cell and the following cells are updated with vlookup etc.

 

In order to make it client friendly, I insert product pictures manually.

 

Is there a way to also do this automatical

... Read More
18 Views
0 Reply

Hi there,

Is there any way to link other documents in ODfB or Local machine when using excel online?

17 Views
0 Reply

Hello Gurus,

I have a Temperature and Humidity readings from different sensors. 

My Weekly problem is copying their daily readings into their corresponding worksheets.

In my attached worksheets, I have a Raw Data which I put my downloaded readings for a week

... Read More
47 Views
1 Reply
How can I fix the Failed_network error when I download the the attachment?

Thanks

I am putting together an excel spreadsheet that has a column of numbers and I'm needing to know if there is away to create a function that will highlight any missing #'s in the order of sequential order?

How do I set a function to notify that there's a gap

... Read More
67 Views
3 Replies

Hi Leroy,

 

As a variant if numbers in column A you may apply conditional formatting rule

=A2<>(A1+1)

to the range starting from A2. That highlights the cells where the value

... Read More

I am beyond frustrated with microsoft these days. It worked better in 1999 than now. I don't know if it's a software problem but why am i forced to be online. why can't they sell a stand alone software?

the old excel never locked up and did not allow data

... Read More
29 Views
0 Reply
Ok so, my goal with this is to find out how to enter some basic information into a few cells in an inventory management workbook and use either a button or form to read the information from those cells and place a new entry to the respective receiving or ... Read More
17 Views
0 Reply