Stack Exchange Network

Stack Exchange network consists of 174 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]

Questions with this tag should only be about Microsoft Excel and how it interacts with a specific Web application. Questions about Microsoft Excel are otherwise off-topic here.

0
votes
0answers
4 views

Getting the highest value sequential number in excel

I have a list of values in one column. But this contains obsolete entries: PIL.7762.25.xml PIL.7762.24.xml PIL.7762.23.xml PIL.7762.22.xml PIL.7762.20.xml PIL.7762.19.xml PIL.7762.18.xml From this ...
0
votes
0answers
12 views

Flow and Google Sheets automation inserting data stating at a certain cell?

I have set up a form for a user to request a WiFi account through Google Forms and Flow. I already have two columns set up as username and password for all the default accounts I need to add the data ...
0
votes
0answers
15 views

How do I interleave rows of data in Google Sheets or Excel

I have data on several different worksheets and I want to combine into single sheet. The data is text, not numeric. I can do this work in either Google Sheets or Excel. I have: Sheet1 R1 Sheet1 ...
-1
votes
0answers
9 views

Microsoft Excel - Creation of a list of items with quantity [migrated]

How can I include a series of text into another sheet? This shall also automatically filter off all blank spaces in between and form a new list. From table 1 to result in form.
0
votes
1answer
49 views

How can I make a hyperlink from Google Spreadsheet cell to an Excel file?

How can I make a hyperlink from Google Spreadsheet cell to an Excel file? For example the hyperlink is in Google Spreadsheet and opens the Excel file. The Excel file is on the hard disk not on Google ...
0
votes
0answers
36 views

Excel spreadsheet hyperlinks change when uploaded to Google Drive

I've produced an Excel table with hyperlinks in cells from sheets to other sheets. I can't share the Excel document because its confidential but the anomalies are very unusual. One cell contains [11] ...
0
votes
0answers
11 views

Google Spreadsheet How to create tables and refer to a column of the table

As we can create tables in Microsoft Excel and for example do a sum of the values of a column by the following formula =SUM(TABLE1[AMOUNT]) We can create filters in Google spreadsheet but how can ...
0
votes
2answers
42 views

Automatically apply new formatting and remove time from a dynamically added Date-Time in google sheets

I am new to Google sheets and don't know how to write excel/google sheet formula to apply automatic formatting to a date+time value added through an external script. I have a CRM integrated with ...
0
votes
1answer
175 views

Move Google Sheet with a script to Excel

I have a Google Sheet that I would like to access and modify also when I'm offline. The problem is that I have a script attached to it so I can't use the "make available offline" option; the script ...
1
vote
1answer
26 views

Format Google Analytics Date

I'm using the following formula to retrieve week day and day from a Google Analytics report in Google Spreadsheet: =CONCATENATE(CHOOSE(WEEKDAY('90diaspessoas'!A16),"Domingo","Segunda","Terça","Quarta"...
0
votes
1answer
1k views

How convert VBA to Google Sheet script (to lock columns based on data) [closed]

I have VBA on my xlsb. How can I convert it to Google Apps script? VBA on Excel sheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range((Split(ActiveCell(1).Address(1, 0),...
0
votes
0answers
39 views

How to paste tables in Gmail? [duplicate]

I tried to paste table from both MS Excel and MS Word in my Gmail account. But every time it is not pasting as a table instead only the words are coming. The tables does not show in the mail. Any ...
0
votes
0answers
383 views

How to Increase size of textbox in Google Forms for long answer type questions?

Context I use google docs for a lot of applications and recently started using Google Forms. I was using Microsoft Forms, which was working well, but dont have access to Microsoft Forms anymore. ...
3
votes
1answer
43 views

Exporting date fields from Cognito Forms to Excel on Mac transforms date by 4 years

Why, when I export the entries to Excel, does it change date by 4 years and 1 day and how do I avoid it? For example, 18/11/2017 on the screen becomes 19/11/2021 in the Excel version. Please note we ...
1
vote
2answers
42 views

How to Automate Adding Rows of Analysis for Excel Dashboard Feed Integration

I am trying to integrate an Excel dashboard feed through the CommCare dashboard feed link. The dashboard already has multiple sheets and many formulas to process the data entry, which up until now has ...
0
votes
1answer
110 views

What's the equivalent of the SEP metadata in Google Sheets?

I'm using the SEP metadata in my csv files to enable people all over the world to correctly open them on MS Excel. It worked finely until recently some people wanted to open those files on Google ...
1
vote
1answer
133 views

How do I calculate a sum based on a column number which is the value of another cell?

I want to summarize in line 8, all the values in A2:A6. I want the function to get the column number from another cell (B8). Same for line 9. I want A9 to summarize b2:b6. In other words: How to add ...
0
votes
1answer
79 views

Excel spreadsheet into body of Gmail message without losing formatting

I am trying to copy and paste an Excel spreadsheet into the body of a Gmail message. I know I can attach it but the recipient can't receive attachments. The formatting stays but not the borders/...
3
votes
1answer
4k views

Is it possible to link a Google Form to a desktop Excel sheet so that when someone fills in the form the data goes into the Excel sheet?

I work for a sporting organisation and track all sorts of monitoring variables using Excel spreadsheets. Up until now I have used macros in Excel to do this, but this requires players taking it in ...
1
vote
1answer
1k views

Excel to Google Spreadsheet problem

I emailed an Excel spreadsheet as an attachment to my Gmail account. I then chose open as a Google Spreadsheet. When I opened the Google Spreadsheet, it was missing some formulas and had changed some ...
12
votes
4answers
15k views

Export Trello data to Excel

I am using Trello as the Scrum tool of choice but need a way of exporting data to populate my burn down charts. We are using Google Chrome but have data security concerns, so exporting to Excel is ...
5
votes
3answers
5k views

How do you insert an Excel sheet as part of a new mail message?

I tried inserting a MS Excel document directly / via a Microsoft document but when copied into a new Gmail message the formatting wasn't retained. How do you insert an Excel sheet as part of a new ...
-1
votes
3answers
714 views

Formatting Excel sheet to organize data properly [closed]

I have an Excel sheet which has approximately 2000 Rows. The columns are First Name ,Second Name, email 1, and email 2. I want to be able to use all these contacts in one go in Gmail in the following ...
9
votes
2answers
10k views

What is the equivalent key in Google Spreadsheet to Excel's F2 for editing a cell?

In Excel When you want to edit the highlighted cell, and you don't want to move back to the previous cell when pressing the <- key, you press F2. Pressing F2 ensures that when you're editing the ...
6
votes
0answers
795 views

How do I get my data out of Trello? [duplicate]

Possible Duplicate: Is it possible to export my data from Trello, to back it up? Is there a way (or is it planned) to export Boards, Lists or specific cards to an external downloadable file of ...
3
votes
2answers
5k views

Is there a way to search and replace a regular expression in Google Docs spreadsheets?

The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
25
votes
8answers
18k views

What limitations does Google Sheets have in relation to Microsoft Excel? [closed]

Office licenses are expensive. What features of Microsoft Office are missing from Google Sheets that would be of value in ordinary personal or business use?