Questions tagged [microsoft-excel]

Questions with this tag should ONLY be about how Microsoft Excel interacts with a specific web application. General questions about Microsoft Excel are off-topic here but can be asked at Super User.

Filter by
Sorted by
Tagged with
-4
votes
0answers
13 views

VBA Syntax into Java

anyone can help me translating this VBA code so that I can use it for google sheets? Would be awesome. ​Sub test() Dim row As Integer Dim row2 As Integer row = 1 row2 = 1 Do While (Cells(row, ...
0
votes
1answer
23 views

How tell Google Sheets to not change columns width?

I wrote a script that generates excel files. In those files, I add images inside cells. I set the width of the images cell by calculating the total images width. Here is how it looks in MS Excel: And ...
0
votes
0answers
9 views

Browser app for editing excel files by formular

I have an large excel file with a lot of different tabs in Microsoft excel (laying in OneDrive). I want to create some formulas to make editing and viewing easier and more structured (like any web app ...
1
vote
1answer
34 views

Excel: how to move “answers” rows into under column “questions”?

How do I move answers from other column to same question under another column, can any one guide the exact formula to achieve this? See example below what needs to be achieved as shown in picture.
1
vote
0answers
8 views

Export Google bookmarks into an excel sheet

I have a bookmark folder where I have bookmarked various professor's profiles. There are some 40 bookmarked links. I wanted to know if there is a way I can export the bookmark in an excel sheet with ...
2
votes
1answer
10 views

How do I write a formula while referencing another sheet in Google Sheets?

So I want to do a CountA on Column A and Column B in Sheet Two and divide Column A by Column B in Sheet One to get the percentage totals. Can I write all that in one line? =SUM(Sheet!((COUNTA(A2:A516)/...
1
vote
0answers
7 views

Changing the value of a single cell based on 2 different cells

By using the IF function I am controlling the value of a cell based on the values of a different cell. For example: If the date in Column G is bigger than TODAY() then the value of column N is "...
0
votes
0answers
20 views

How to use Google Finance to query a stock price during a specific time period

I'm trying to get the high and low price for particular tickers during the after market and premarket hours. Is there a way to query google finance for highs and lows between the after hours of 1:00-5:...
0
votes
1answer
8 views

Excel formula to skip the rows with zero value while linking

I need a small help in fixing my formula. i have a report from erp with few employees name and the amount they owe. It is a dynamic report and changes everyday. My requirement is that I need a formula ...
0
votes
3answers
34 views

In Google Sheets or Excel, how can I write a formula to SUM() a range based on the criteria that none of the respective cells are blank?

What I want to do: +------+--------+---------+-----------+----------+--------+-------+------------+ | Week | Monday | Tuesday | Wednesday | Thursday | Friday | Total | Difference | +------+--------+---...
-2
votes
1answer
24 views

Turn an excel sheet to a webpage

I have an Excel sheet that we use to calculate sales commissions. We, sometimes, share the file with individuals that we prefer they don't see the formulas. One thought came to mind is to convert the ...
0
votes
2answers
10 views

Add % sign in Data Labels Google Sheets

I have a simple chart in Google Sheets. Currently, the data labels are just numbers. I want to append a % sign infront of each value. How can I do so? https://docs.google.com/spreadsheets/d/1wyubPje-e-...
1
vote
2answers
49 views

I wrongly set the date of 2000 cells. I want to add 20 years of those cells. How?

My first thought was to add a duplicate cell and show the formula as general number. add another cell that adds 20 years worth of days. change the third cell formula back to date. But I feel like ...
0
votes
1answer
63 views

Use Text in cell as formula in Google Sheets

I am working on a way of building out a formula rather than a bunch of if/then statements. Is there a way I can convert the text from one cell and use that text as the formula of another? Example: A1 ...
1
vote
2answers
31 views

IF Statement works in Excel but not G Sheet?

I have a simple IF statement in Google Sheets that is not computing correctly but it is computing correctly in Excel. The formula is =IF(G15="TRUE",1,0) and G15 is a cell with "TRUE&...
-1
votes
1answer
9 views

EXCEL workbook - How to put on a website

I am using EXCEL from Office 2003. I want to know how I can put a workbook on to a website I have in such a way that a user can simply download it to his machine and then use it. The workbook has some ...
1
vote
1answer
57 views

Creating Hyperlinks of Google Drive Items in Alphabetic Order

The original post that I got the google script editor code from was here: Get share link of multiple files in Google Drive to put in spreadsheet It works perfectly fine, but what I want to do is show ...
0
votes
0answers
17 views

Excel Text, Number, Variable Deliminator Split using VBA

I have a very large work request data set that I need to clean up. The data set has some consistent elements there are a series of numbers that are a set length this is changes about about half way ...
0
votes
0answers
10 views

Data validation

Two separate workbooks: the 1st workbook - Has Customer Data - Name, Address, Contact etc. the 2nd is an invoice which as cells to add the Customer Name etc What I require is to extract data from ...
1
vote
1answer
130 views

Why do Google Sheets and Excel give different exponential regressions?

I have the following simple set of data: xi yi 1 2 2 1 3 4 4 6 5 6 6 10 When I draw it on a chart and then add the best exponential trendline, both in Google Sheets and Excel, I obtain ...
0
votes
1answer
329 views

How to organize and add multiple tags to a list?

I'm trying to create a sort of "goal bank" and I'd like to organize it so that you can search for goals based on various categories (i.e. diagnoses [autism, mental health, etc.], domains [social ...
0
votes
1answer
244 views

Google Sheet day() formula returns wrong day name

I want to get Day name from a specific date on Google Spreadsheet (also tried on Microsoft Excel Online). I have written specific date on a cell B1: 2020-03-31 then custom number format it as: yyyy-...
0
votes
0answers
42 views

How can I SUMIF a row, but have the formula automatically applied to all new rows below it in Google Sheets?

I've made an inventory tracking spreadsheet that gets raw data from Google Forms. Forms inputs data into Sheets in a less than ideal way, but there's nothing I can do about that, so I'm stuck post-...
0
votes
1answer
26 views

How to get maximum value from rows, only from specific columns

My sheet looks something like this: https://docs.google.com/spreadsheets/d/1IbHLts4V4hyc2bo_TfgZzZhFiMXkD5FSlPlpSm7xloY/edit?usp=sharing How would I make a formula for the max/min columns, to get the ...
-1
votes
1answer
27 views

EXCEL: If cell x exists in column A then print row 2

I'm currently looking at a set of data like this: What I want is: If I enter something into G22 that exists in row A I want G25-G35 to show the content of 2A-2K respectively, else say blabla. I have ...
0
votes
1answer
32 views

if cell B4=B1:B2, countif C1:E2=AAA

If have 2 tables. I need the count of AAA for a particular name in Table 2. Example: I need to count the number of times AAA occurs for Peter.
0
votes
0answers
12 views

Formula Parse Error in excel

=[20150*(.036/12)*(1+(.036/12))^60]/[(1+(.036)/12)^60-1] This is the formula I am putting in excel and it won't work. The correct answer is 367.4667 Can someone please help, everytime I type this ...
1
vote
1answer
78 views

Excel to Google Sheets Script

I am using a script below for excel to pull a certain row value from one sheet to another cell on a different sheet. I just want to know if this can be done with google sheets thru script and if it's ...
0
votes
1answer
2k views

Rich text formatting in a Google Sheets cell

How is it possible to enable "rich text formatting" inside a single Google Sheets cell? I'd like to have a cell containing some text with both bold and non-bold content, words in italic, with some ...
-1
votes
1answer
26 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
1answer
702 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
652 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
1answer
948 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
46 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
3k 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),...
3
votes
1answer
52 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
67 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
233 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
686 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
100 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
6k 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
5answers
16k 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
721 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
14k 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
801 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. ...
26
votes
8answers
19k 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?