Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
8 views

combine all phone number into one cell and separate use ;. If only 2 phone number, then leave as blank [on hold]

What is the formula for combine all phone number into one cell and separate use ;. If only 2 phone number, then leave as blank. Thank you for your help!
0
votes
0answers
12 views

How to show my full title when hiding adjacent cells?

My title is in A1, it is a large title. I am hiding column B. When I print preview, I lose half of my title because B is hidden. Is there any way to print the entire text in A1 correctly while hiding ...
0
votes
1answer
11 views

Copy DUPLICATE values from two columns into a third column

This is similar to another post: Copy unique values from two columns into a third column I am looking to do the Opposite of this: Here's the gist... Two separate things I am looking for from 5 ...
0
votes
0answers
13 views

Why does Ctlr+P bring up randomly different print windows in Excel?

So I'm doing nonsense with SendKeys (Duplex printing >_>), and for some reason, Ctlr+P (seemingly) randomly brings up two different dialogs - the normal one, and something the "old" one. Why is this?...
0
votes
0answers
6 views

Drag and drop excel file into another excel Column A

Need your help. I have two spreadsheets, spreadsheet A is where all functions and power query is working and spreadsheet B where raw data is located. Could you please help me out how can I drag the ...
0
votes
0answers
18 views

Excel text box content to cell

I know there is an option to link cell content to text box so once you type to cell something it will be displayed in text box. Is there something similar but vice versa? Once I type to text box it ...
0
votes
1answer
15 views

Dynamically Changing Excel Chart

I have a range based table the has months April-March on row 1, then two metrics on rows 2&3 for those months. I have created a line chart based on the whole table and it works fine. But at the ...
0
votes
0answers
11 views

Files Move one location to another location based on cell value

i want to copy the files one location to another location based on excel cell value. colmn b contains file name column c contains SOurce path and Column D contains Destination path. please help to ...
-1
votes
0answers
12 views

Fill in table with 12 months overview in function of months via VBA Excel 2010

The table in the image has a 12 month period overview, in this case from FEB 2018 to JAN 2019. And come next month, the table will be updated and as a result start from MAR 2018 to FEB 2019, APR 2018 ...
0
votes
0answers
15 views

Auto filter & copy data

I have an Excel file with data: So I want to sort this data as per this image: Then after that I want to filter data as per sorting order, then copy data in other sheet or other excel file (with ...
2
votes
4answers
31 views

Is there a text editor which displays column numbers and/or displays text in a grid to quickly glance column numbers?

I basically need a text editor which displays text in a grid, so that I can know the exact column numbers of the text. The numerical simulation software I am using, TOUGH+ (written in FORTRAN), has a ...
0
votes
2answers
24 views

Excel formulas given certain value of cells

My data looks like this: data I have 500 companies, i is the identifier for each company, t is the time period (1-5000 for all companies), r is the return and mktcap is the market cap. The data goes ...
0
votes
1answer
17 views

Formula Countifs

I need a bit of help, I am in need of counting a few things but I need to ensure they are unique to avoid a duplication issue. So here it is Column 1 Column2 Column3 1030 ...
0
votes
0answers
14 views

I'd like to have a checkbox on one sheet send information to another sheet in excel

So I want to have a database of materials I use often with other information like cost, relail and available lengths et cetera. Then check the box next to it and have it populate on another sheet ...
1
vote
0answers
23 views

Convert a date & time text string to a date?

A program I use exports its measurement dates as MM/DD/YYYY HH:MM and excel sees it as text. How do I convert that so that excel recognizes it as a date? Also, the length of the text string varies (e....

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 |