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
0 answers
11 views

Lookup In Multiple Sheets & Add Unique Identifier

I'm trying to create an email lookup worksheet that essentially lists the results of a search throughout multiple worksheets (all in the same Sheet document). As an example, I have "Sheet 1",...
user avatar
  • 1
0 votes
1 answer
26 views

Check if any cells in one column fall between cells in different columns in Google Sheets

So I'm trying to figure out if any call for service happens during the time frame of another call. The information is set up below like this: | |[A]|[B]|[C]| |:---|:---|:---|:---| |1|"Call Time&...
user avatar
0 votes
0 answers
4 views

How to organize orders in table [migrated]

I am new in the world of Excel so please advise. I have a table like this, the vertical axis is a date, and the horizontal axis is the order numbers and the number of items in each. Orders have ...
user avatar
0 votes
1 answer
35 views

How do I put the if function inside the lookup? - Daily Routine sheet

I have a sheet - daily routine which has two columns: activity and time as shown here Activity Time Sleep 😴 6:00 am Toilet 🚽 6:15 am Get ready for gym 🤸‍♂️ 6:30 am Exercise 💪 7:50 am ... ...
user avatar
  • 101
0 votes
0 answers
18 views

How to approach this? Which formula should I use?

I am working on a Google Sheet in which I am classifying a "product" with an id number and I want to pull out data from another sheet that contains 2 things: confirmation of the id type of ...
user avatar
0 votes
0 answers
27 views

Multivariable Matching in Google Sheets - scanning for multiple values simultaneously and posting shared data

I have two sheets from two different sources (Facebook Ads and Google Ads) and I want to match their data onto a third sheet. The data itself is different, but the identifiers are the same - campaign ...
user avatar
0 votes
0 answers
23 views

How can I combine the data of rows with duplicate data in one column and different (but sometimes repeating) data in another column?

I'm working on a spreadsheet that contains the data of lots of organizations. I'm importing some data from an existing spreadsheet which contains a lot of duplicate data in the "organization name&...
user avatar
  • 13
0 votes
0 answers
13 views

Array formula giving error of different sizes

I am trying to create a formula to count based on two different set of or conditions. If I remove the second array ({BB$3,BB$4,BB$5}), then the formula works but when I add the second condition it ...
user avatar
0 votes
1 answer
61 views

Lookup between two dates in Google Sheets

I have one sheet with the following information: In another sheet I have the following: How can I fill in the cells in column B in my first sheet, based on the date? The date should be between the ...
user avatar
  • 103
0 votes
2 answers
26 views

Select full column in Google Sheets by [@column]

In Microsoft Excel I know I can select a row by: Inserting a table (table name "Table1") with header Select column by = Table1[@ColumnName] How can I do this in Google Sheets?
user avatar
  • 103
0 votes
0 answers
17 views

Given a table of csv values is it possible to receive suggested formulas? Alternatively is it possible to "solve" a complicated formula given a table?

i.e. Given the csv table with A1=1,A2=2,A3=3,A4=4,B1=10,B2=5,B3=10/3,B4=2.5,C1=0.48,C2=0.24,C3=0.16,C4=0.12,C5=1 Row A B C 1 1 10 0.48 2 2 5 0.24 3 3 0.333 0.16 4 4 2.5 0.12 5 1 Only A1:A4 are ...
user avatar
  • 1
-1 votes
1 answer
222 views

Replacing text of links in google sheets

I have a bunch of links in cells in my google sheets. I want to replace all the text of them all just to say "LINK" so that when I click on them it's still hyperlinked to the correct site. ...
user avatar
  • 1
0 votes
1 answer
28 views

Google Sheets - Multiple countifs

Example scenario: (picture added) I want to find out how many people had reason "No access to accommodate patient" at location A during February 2022. (more like filling up the table) How ...
user avatar
0 votes
0 answers
16 views

Calculating Revenue per Hour Using Pivot Tables

I have a following spreadsheet with the following columns: (Note: Datetime is aggregated as 1 field, it was broken to the Month & Day column for clarity) Month Day Operating Hours (Hrs) ...
user avatar
  • 1
0 votes
0 answers
10 views

Google spreadsheet help for putting correct formula to automate operations

Your help can save my lots of time & energy, I am new to google sheet & don't know much abount coding, i have made a google sheet to automate our therapy clinic operations by internet learning....
user avatar
0 votes
1 answer
28 views

Unique numeric ID

I have a spreadsheet that gets its data from a google form. I use a formula I found on a forum to generate a unique ID and assign it to every entry avoiding repetition. =arrayformula(if(len(B2:B);&...
user avatar
  • 1
0 votes
1 answer
51 views

A way to "lock" and "unlock" a Google Sheet's contents

How can I create a cell lock / unlock mechanic in Google Sheets similar to Excel? NOTE: I know how to protect a google sheet and limit editing permissions to certain users. There are many similar and/...
user avatar
  • 103
0 votes
1 answer
25 views

How can I change the min and max value of vertical axis in chart?

I want the vertical axis to range between 75 and 125. The min should be 75 and the max should be 125. 0 to 125 range is automatically generated. The highest data point is 107 and the lowest data point ...
user avatar
0 votes
1 answer
15 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 =...
user avatar
0 votes
1 answer
25 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 ...
user avatar
0 votes
0 answers
15 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 ...
user avatar
1 vote
1 answer
22 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 ...
user avatar
0 votes
1 answer
12 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 ...
user avatar
  • 625
0 votes
1 answer
14 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 ...
user avatar
0 votes
1 answer
93 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 ...
user avatar
  • 77
1 vote
2 answers
66 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 ...
user avatar
  • 77
0 votes
1 answer
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 ...
user avatar
-1 votes
1 answer
17 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 ...
user avatar
0 votes
1 answer
114 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 ...
user avatar
0 votes
1 answer
108 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 ...
user avatar
  • 1
0 votes
1 answer
17 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.. ...
user avatar
1 vote
1 answer
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 ...
user avatar
0 votes
1 answer
15 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 ...
user avatar
0 votes
1 answer
25 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 ...
user avatar
  • 1
0 votes
0 answers
26 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 &...
user avatar
  • 1
0 votes
1 answer
27 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". ...
user avatar
0 votes
1 answer
35 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 ...
user avatar
0 votes
1 answer
25 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 ...
user avatar
-1 votes
1 answer
338 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 ...
user avatar
0 votes
1 answer
82 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 ...
user avatar
  • 101
0 votes
1 answer
39 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 ...
user avatar
  • 9
1 vote
1 answer
57 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 ...
user avatar
2 votes
1 answer
24 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)/...
user avatar
1 vote
0 answers
19 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 "...
user avatar
0 votes
3 answers
69 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 | +------+--------+---...
user avatar
  • 101
-2 votes
1 answer
34 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 ...
user avatar
1 vote
2 answers
59 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 ...
user avatar
  • 19
0 votes
1 answer
1k 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 ...
user avatar
  • 113
1 vote
2 answers
56 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&...
user avatar
  • 11
-1 votes
1 answer
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 ...
user avatar