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
0
votes
1answer
14 views

Format cell If date is in the current week [closed]

I have a few dates in Column "A" and I want to highlight cells that have dates from the current week. How to do it in Excel Or Google Sheets?
0
votes
1answer
11 views

EXCEL Formula that calculates price after percentage discount, but needs to ignore a "-" to show no discount =IF(I40<>"-",(I39-(I39*I40)))

So I have a formula for adding subtotal after a percentage discount is taken off. (I39-(I39*I40) I also have a dropdown list for percentages so 10% 15% 20% and none labeled as - This is what I have =...
0
votes
0answers
8 views

Combine Multiple Cells with Dates into one Single text sting cell [migrated]

Setting up and invoice system and i'm trying to make as much of is automatic as possible. I've set it up with a week ending date/formula that auto fills the days of the week Monday thru Sunday. My ...
0
votes
1answer
21 views

Google Sheets Formula Not Working in Excel

I have this formula pasted below that works in Google Sheets, but not in Excel. I've looked up possible solutions, but just cannot find what may be the problem with it. The return I get is just the ...
0
votes
0answers
11 views

Google Sheets Merging two sheets together with common rows and uncommon rows

I have two Google sheets each with 4000 columns and 8 rows. I would like to merge these two sheets together using 6 of the common columns and writing over 2 of the uncommon rows. Into a new sheet. Is ...
0
votes
0answers
4 views

How to open excel always from top? [migrated]

Is there a way to set Excel behavior to opens always on top of the worksheet? A lot of us are working on a long sheet and it would help if it opens on top and not where the last one saved it. I do not ...
1
vote
1answer
12 views

Google Sheets Conditional Formatting rows based on color adjacent

I am using Google Sheets to make a homework spreadsheet and have used conditional formatting to arrange assignments by the due date and also each class has a color. When I type in a class it ...
0
votes
1answer
10 views

How can I highlight the source cells in a formula (e.g. =SHEETA!$E$568 )

I have a sheet that makes extensive use of cells from another sheet with formulas, some of which have errors. The formulas look like: =SHEETA!$E$568 Is there a way, or a script, that can parse the ...
-1
votes
0answers
18 views

I can't seem to be able to Import a data value from a website

I can't seem to be able to Import a data value from a website. Can Anyone help me? The website is https://alternative.me/crypto/fear-and-greed-index/ and the value i'm trying to extract is the one in ...
0
votes
1answer
12 views

Whats wrong with this formula in Google sheets? Im trying to get info from another sheet, but I need the cell to be dynamic

Heres the formula: ='Sector info'!(CONCAT("C", B2)) there's 2 parts to it, the part before the ! which references another sheet, and the second part, that lets me change the row im looking ...
0
votes
1answer
31 views

How do I correct the automatic borders that are scripted into this Google Sheet?

I have this Google Sheet document that already has functionality built in which applies automatic borders. I don't know how it is doing this. I've tried looking in the Script Editor, but I don't see ...
1
vote
2answers
40 views

Transferring an Excel document to G Sheets, how do I fix the slightly broken auto-borders implementation?

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders. Here is the same spreadsheet ...
0
votes
1answer
19 views

How do I get data from the 'Statement' sheet to automatically sort into the 'Expenses' sheet?

https://docs.google.com/spreadsheets/d/1xrS8_Lcuqt3rLJgEkV4SHR_XTyGCAn8t9dJyWIUtMJ0/edit?usp=drivesdk So it will read columns B & C, Everyday > Groceries on the Statement sheet and that amount ...
-1
votes
1answer
16 views

How could I copy information from multiple cells that share a common feature into one cell?

I have a list of codes that are each assigned to a specific bigger case code and I would like to put a list all of the smaller codes that share one bigger case code in one cell. for example D2-D6 are ...
0
votes
1answer
32 views

Google Sheets - Turning text in cell into an image

I was wondering if it's possible to turn text into a picture. For example the text "Arizona Cardinals" is imported automatically into a Google Sheet and that cell recognizes "Arizona ...
0
votes
1answer
47 views

Return a list if 2 criteria match in Google Sheets

In an effort to organize staff training: So far I've made the pivot table, but I'd like for the pivot table to extract who needs which training, as a list in one cell. I tried using =JOIN, but I have ...
0
votes
1answer
16 views

How could I convert a Google Sheets in to a excel file?

I am trying to convert the attached document into a excel file .. It contains a scrapped websites that is constantly updating ... I want the same feature such as the conditional formatting to occur.. ...
0
votes
0answers
21 views

Odd "wrap text" behavior for formulas

I'm writing some custom functions to help automate a process, but one issue I'm noticing is that they do not wrap properly. Steps: Enter some amount of text that exceeds the width of the column. ...
1
vote
1answer
24 views

Sheets or Excel - sum values in column a for each unique date and time in col b

I have two columns. One is a value, the other is a date and time: A. B. 01/01/21 5.15 3 01/01/21 5.15 2 01/01/21 5.15 4 01/01/21 5.30 2 01/01/21 5.30 3 I want ...
0
votes
1answer
14 views

Keeping referenced data organized after sorting

I run a Cub Scout Pack, and when scouts fundraise, a portion of the money they earn can go into an "account". Money can then be used to pay for scouting-related activities. I'm trying to ...
0
votes
1answer
23 views

Getting the latest date of something happening (with conditions)

So basically, I've got two sheets. One (sheet_1) with every single record in the system (over 11000 rows) and the other one (sheet_2) is querying information from that sheet. The relevant information ...
0
votes
0answers
24 views

Max sum held over a month

I need help with a formula that needs to calculate the max sum held at one time for each month. In this example it would be 54 for March (12+13+14+15, held on the 29/03/2021). Month is determined by &...
0
votes
1answer
24 views

"Export to Excel Default" when pasting cells into Google sheet from Excel

Sometimes, as I copy data from cells in an Excel sheet (1 or more cells), when I paste the copy into a Google sheet, it will include a first row with the content "Export to Excel Default". ...
0
votes
0answers
16 views

How to conditional-format text of a cell using a colour scale in MS Excel?

I know how to do this conveniently with the background colour of a cell, but when it comes to the font colour itself there seems to be such no automated method. I have searched throughout this site ...
0
votes
1answer
33 views

How to align data in a Google Sheets spreadsheet?

I have two tables. Table: ID NAME A01 John A02 Peter B01 Marta Then I have a second table (note that this table purposely has more entries). ID ...
0
votes
1answer
18 views

Data validation with specific condition

I have special conditions for column in Google Sheets which are: should only be filled with numbers no special characters allowed no alphabets allowed no space allowed should be 16 digits in total I ...
0
votes
0answers
11 views

Google Drive search do not found Excel files by sheet names

I have several .xlsx file shared in Google Drive. When I do searching, Google Drive never found any file (on of those .xlsx) if searchable name is in second/third etc .xlsx sheet? If name which I do a ...
0
votes
0answers
10 views

Obtain breakdown based on a different column

Is it possible to obtain nested values of a column immediately after the value they are related to from another column? Basically, I have a value (Order Item Cost coming from a unique Order Item Id), ...
0
votes
0answers
13 views

Auto-sorting in Google Sheets and excel by custom valued sorting

I want my data to be auto sorted by 2 columns every-time I append or change values. Also sorting is not just A to Z or Ascending/Descending but Custom valued sorting as example shown below: High ...
-1
votes
1answer
206 views

What's the best way to upload a million row spreadsheet as Google spreadsheet? [closed]

I have an Excel spreadsheet with over a million rows that I would like to have as a Google sheet. I tried uploading the file as a CSV to my Google drive, which worked. Then I tried opening it as a ...
0
votes
1answer
57 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
1answer
37 views

How to move “answers” rows into under column “questions”? [closed]

In Excel, 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 ...
1
vote
0answers
33 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
20 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
14 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
3answers
62 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
32 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 ...
1
vote
2answers
56 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
748 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
44 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
10 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
147 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 ...
1
vote
1answer
597 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
2k 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
2answers
1k 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
118 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
33 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
72 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 ...
-1
votes
1answer
35 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.
1
vote
1answer
119 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 ...