Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

0
votes
0answers
4 views

Why won't my spreadsheet accept formula with “&”

My excel spreadsheet won't accept a formula with the "&" in it. For example =A1+A2&" OK" and if A1=1 and A2=2 then the result should be 3 OK. This same formula works in another spreadsheet but ...
0
votes
1answer
4 views

How to convert names created with Excel's Name Box from workbook-scoped to worksheet-scoped?

I created A LOT of names of cells in an Excel worksheet using the Name Box (to the left of the Formula Bar). Then, I decided to make a different version of the worksheet in the same workbook. And then ...
0
votes
0answers
8 views

Word Merge with Excel Datasource

I have a single page Word doc. I have an Excel sheet with multiple rows of names, addresses, etc. I'm trying to get each row to merge into the Word document line by line and NOT create a new ...
0
votes
1answer
20 views

Excel - Need to compare two times in order

I am using excel to compare two date columns that i need to compare. One is an Expiry time (SLA Expiry Time) and the other one is when it was actually updated (Initial SLA Contact Time). It is to ...
0
votes
2answers
15 views

Need help leaving a cell blank if the formula has no sum value

I am using the below formula to calculate attendance and I would like the summary column to remain blank if there is no value entered from columns B12:AF12. What am I missing to make this happen? ...
0
votes
1answer
12 views

Sum, Match and Index Across Multiple Criteria

I've spent the last hour unable to get through a relatively straight forward problem. I would like to sum a range of cells, however it cannot be a fixed formula as the rows and cells will change ...
0
votes
0answers
12 views

Excel crashing when opening file

When trying to open an excel workbook I get the standard Microsoft Excel has stopped working... and it crashes. If I open excel first (on a blank document) I can click on workbooks to open them or ...
1
vote
2answers
23 views

Counting a column if a specific string is in another

I have a column of ranks and I need to determine the count of each rank (1-5) as long as its tag (column 1) is the same as the tag specified on the output table. This is to be placed into a separate ...
0
votes
0answers
9 views

Find relationships between projects in an Excel list

My problem is about finding relations between participants who have participated in different projects. In my Excel list, column1 is a list of participants and coulumn2 is a list of the project each ...
1
vote
2answers
9 views

Box - Excel Online - Sharing a workbook

How do you share an Excel workbook in Excel online? We have a file that we need multiple people to access and update, when it is opened by a user the following error message is displayed and the file ...
0
votes
0answers
11 views

Partially automated receipt scanning & formatting to excel spreadsheet

I need a way to scan a bunch of till receipts at the end of every shift into excel. We have a futjitsu ix500 scanner but I think additional software is required such as ABBYY finereader. Where there ...
0
votes
0answers
11 views

Written Excel VBA to Copy text from one Word document to another Word document - Footer formatting is not retained

Please help me on the issue. I have successfully copied the content from one word document to another word document. But the footer format is changed after paste the content. Below is my code. Sub ...
0
votes
0answers
14 views

Pivot on Case Ageing and groups them based on time passed showing the months not hours

Trying to pivot the time difference and group them into hours like 0-4 hours 5-8 Hours 8 Hours + Got the time difference but can't figure how to pivot and get the groups. Excel link
0
votes
0answers
14 views

Is it possible to keep selected cell further from the bottom of Excel screen - i.e. to auto-scroll before you reach the bottom

Hard to explain this one. Imagine you're in Excel, pressing the down key to move down through the rows. Once you get to the bottom of the screen, pressing the down key again will cause the ...
0
votes
0answers
5 views

VBA - Edit listbox item in separate textbox, but how to update database?

My code below is able to pull numbers into listbox via RowSource. When double-click, it feeds two numbers into two textboxes, per screenshot below. What I cannot figure out for 5 hours now: If user ...

15 30 50 per page
 Microsoft office activator |  windows activation crack |  windows product key |  windows 10 product key |  windows 7 ultimate product key |  windows 7 keygen |  activate office 2010 |  office Project keys |  project professional product key |  office 365 office 2016 office 2013 key |  office 2016 office 2013 key |  windows 7 professional product key |  windows 8 professional product key |  windows 10 professional product key |  office 2016 professional product key |