Questions tagged [spreadsheet]

Questions about spreadsheet software in general and interoperability between spreadsheet programs.

Filter by
Sorted by
Tagged with
0 votes
1 answer
28 views

How to select and copy entire row based on text-value in a cell in excel

I would like to do the following: Find all cells containing a certain keyword in a column in an excel spreadsheet. Select and copy the entire row which includes the cells which have the keyword ...
user avatar
-1 votes
0 answers
20 views

Microsoft Office Professional Plus Excel Spreadsheet data transfer?

I want to begin by saying thank you for taking the time to read this. Okay, I am in charge of creating a series of Excel worksheets for a company. I have an idea on how to make it but I am curious if ...
user avatar
0 votes
0 answers
22 views

Summing rows in excel if a criterium is met in any of several columns

I've been googling this issue and playing around with SUMIF and SUMIFS for a while now, and I'm pretty convinced now that neither of these operators can really achieve what I'm looking for. Maybe ...
user avatar
0 votes
2 answers
29 views

How to fill a spreadsheet with the information from another spreadsheet?

Given a main spreadsheet table initialized as code property A property B A001 A002 B001 C001 and another table containing things to update the main table code property A property B A002 foo ...
user avatar
0 votes
0 answers
8 views

Is it possible for spreadsheets to fix a value after calculation even if references change afterwards? [migrated]

What I want to do is that a cell gets calculated and it never gets calculated again, or a workaround. My use case is this. I have a google spreadsheet where I have two percentages, those percentages ...
user avatar
  • 331
1 vote
0 answers
6 views

How create increment column in visidata from a set value, not for 1?

If I have I frame with 10 rows, and I create a new column with za and then use gi I get a range column from 1 to 10, but instead of that I want to get a range column from 15 to 25. How can I get that?
user avatar
0 votes
5 answers
40 views

How to keep a spreadsheet cell reference fixed when rows are inserted?

Say I have a Google Sheets or Microsoft Excel spreadsheet where the formula in cell A1 is "=SUM($A$5:$A$100)". Assume there is data is cells A5 through A10, but nothing (yet) in A11 through ...
user avatar
  • 4,088
0 votes
1 answer
43 views

Excel File with more than 100k rows has errors

i would like to know if there is a way to fix excel's problem: i have a file with more than 100k rows, and everytime i am using filters in columns it doesn't really show everything after, there is a ...
user avatar
0 votes
0 answers
60 views

Evaluate function not working

In the example, entering the combined values in K2 as a formula produces the result in J2. J2 is value copied and pasted in J4. To confirm that it is a formula that will not produce an error, the ...
user avatar
0 votes
1 answer
38 views

Lookup the 1st or nth appearance of value between two dates

In the example, column C is used to track the fast food consumed. The goal is to set up cell H2 to find the 1st fast food consumed between the dates in cell F1 and F2. H3 will be used to find the ...
user avatar
0 votes
1 answer
62 views

Can we add tags in any spreadsheet software like we can in Notion?

I’m working on long tables (like a database or repository, no mathematical function) and I need to refer a few cells in another sheet And also use some tags for each row. I know in Notion, you can ...
user avatar
  • 145
0 votes
1 answer
44 views

Link to a specific Microsoft 365 Excel sheet

Can I construct a link from a website to a specific sheet (called Admin) or a named range (called Status) in a workbook originally created by Microsoft 365 Forms in my account? I have a share link ...
user avatar
0 votes
1 answer
33 views

Automatically duplicate the same formula when adding new rows

Let's say we have a formula in column B, for example =LEFT(A2; FIND(" "; A2)) but it could be anything else. How to make that, when adding a new row in the future (here on row #4), the ...
user avatar
  • 1,636
0 votes
1 answer
21 views

Split cell then Vloop then sum

I have a google form linked to a google sheet. There is one multiple choice checkbox question in the form that asks the user to check A, B, C. In the google sheet, the answer are concatenated with a ...
user avatar
  • 183
0 votes
1 answer
19 views

How do I syntax a simple logarithm in a spreadsheet formula?

simple logarithm How do I syntax this question in a spreadsheet formula? Trying to find N. (see image on at top) Don't know how to write the formula for this, or what function to use. s = 4 e = 2000 ...
user avatar
0 votes
2 answers
79 views

Excel Sort Command not working AT ALL as expected

I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways: the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
user avatar
  • 3
0 votes
1 answer
42 views

Microsoft Excel - How can I convert the following text to 'date' only format?

I have text in a cell with the following syntax: Jan 6, 2022 10:18 AM The standard format adjustment from 'general' to 'date' does not work. I need to convert the text into a date-only format (ideally ...
user avatar
  • 1
0 votes
2 answers
28 views

One-click solution to expand a row to full height (that shows all the data)

Is there a one-click or keyboard-shortcut solution to enable/disable "Wrap text" to all cells of the current row? This would allow a better edition of the current row, and being able to do ...
user avatar
  • 1,636
0 votes
1 answer
64 views

Create new lines after comma in spreadsheet?

I have 2 sheets on google sheets/excel, I'm attempting to create a new line after each comma (if one is present), so it's easier to see. I've tried using regexreplace and substitute but I just can't ...
user avatar
0 votes
2 answers
37 views

Looking up a value from a table(section) that fits certain criteria

I know the function LOOKUP which can be used to look up a specific value for a given key. However, I have data like this: --+--A-+---B----+---C----- 1 | Key Start End 2 | 1 1.60 1.67 3 | ...
user avatar
  • 565
2 votes
1 answer
36 views

Change shelves into separate columns

Every day I have an inventory to do. 100 or so items on 15 or so shelves. I also have an xml report that shows what should be available in the room - but this xml does not show what shelves the items ...
user avatar
0 votes
2 answers
132 views

How to get the type of a cell in Libreoffice Calc?

I would like to know if a cell is a date, a number, a string or what. It would help a lot, exactly what/how should be done with it. I think, librecalc knows it, because it affects the behavior of the ...
user avatar
  • 2,372
0 votes
1 answer
53 views

How to combine the values from multiple rows in a column (separated by commas) where there are duplicates in another column

I have a large dataset where I want to combine the values of multiple rows in one column where there are duplicates in another column. See my Example below: CURRENT DATA Product Type Email Product 1 ...
user avatar
  • 135
0 votes
0 answers
25 views

Spreadsheet list referencing another spreadsheet

I am creating a medication calendar. I have a list of medications in one column. I have a column titled 7am and then the contents of the column are how many pills I take at that time. In a separate ...
user avatar
  • 1
3 votes
1 answer
329 views

Include an "at" symbol ("@") in a text cell

I'm organizing some stuff in a spreadsheet. None of it should be interpreted as anything other than than text, but it does contain a lot of non-alphanumeric characters. If I include the character @ in ...
user avatar
3 votes
3 answers
204 views

How to unroll a row in Excel, to have a better view for editing?

Let's say we have an Excel spreadsheet like this: Is there an easy way, ideally built-in in Excel, to "unroll a row" to be able to: have a better view of all the data in this row have an ...
user avatar
  • 1,636
0 votes
1 answer
261 views

How to sum a column based on existance of value in another column

I have the following sheet: I want a sum of individual spending by Frank, John and Nancy in the yellow cells. Each person's spending is denoted by an x. I tried the SUMIF formula, but I don't know ...
user avatar
  • 17.4k
0 votes
1 answer
23 views

In Excel I am wondering how if a value is met in a column then to sum up the cell to the left of that value across multiple rows if that makes sense

For example where the cell says David I want to sum all the cells on the left of David in £ up to a total like at the bottom not sure how I'd go about this. £4500 IWI 14/12 DAVID ...
user avatar
  • 1
0 votes
1 answer
30 views

If Statement Gives Blank Results

I can't get the following IF statement to produce the desires results. Result comes up blank. =IF(B3="168375","500","") Cell A3 = 168375 so am i missing something that is ...
user avatar
  • 1
0 votes
0 answers
84 views

How to prevent updating a cell reference in Google Sheets when new columns are added?

In my Google Sheets spreadsheet, I have sheet A ("Summary") with a few cells that reference other cells in sheet B ("Raw data"): Sheet B contains raw data that is added via API: ...
user avatar
2 votes
1 answer
126 views

How do I return a column value based on whether another column is within an array range - Libreoffice Calc

If I have a comparison array like so on sheet "A"... Size Min Max SM 0 99 MD 100 199 LG 200 999 ...and on sheet "B" I Have... Val Size 50 ?? 250 ?? 150 ?? ... ... How ...
user avatar
  • 267
-1 votes
1 answer
50 views

How to combine cells for common values in another column in Excel

What's the best way to achieve this A 34 ===> A 104 A 5 ===> B 55 A 65 ===> B 32 ===> B 23 ===> Refer to image for readabilty:
user avatar
  • 3
0 votes
1 answer
24 views

Count just columns consecutive in sheets

I am trying to add or count only the values ​​that are consecutive between the columns, that is, I want to be able to identify by name when the condition that there is six times the number one is met, ...
user avatar
  • 1
0 votes
1 answer
18 views

powerbi parse sheets in excel file

I'm importing a list of excel files into PowerBI. So far, I've imported the folder, expanded the files to show the list of sheets, and expanded the sheets to show columns. Here is my code so far let ...
user avatar
0 votes
1 answer
30 views

Excel - I want to get all the cells adjacent to a keyword on a page onto another sheet

I'm using Excel to track what I do every day, which includes a lot of qualitative data, and at the end of every day I write down how many hours are spent in each of several categories. I definitely ...
user avatar
0 votes
0 answers
6 views

Can I control how many colors are used to cycle through the series in macOS Numbers?

I have a spreadsheet in Numbers that has a column of data for each day of a month. If I plot the data with a line chart, I get a series of lines that cycles through six different colors (see an ...
user avatar
  • 160
0 votes
1 answer
40 views

How to add a comma and the word "and", "then" ,"or", and so on to a list in Excel or Google Sheet

=SUBSTITUTE(TEXTJOIN(", ",TRUE,$G3,$I3,$K3),", "," and ",MAX(1,COUNTA($G3,$I3,$K3)-1)) Right now the return is: G3, I3 and K3 (the last comma before "and" is ...
user avatar
  • 1
0 votes
1 answer
24 views

Need help in Excel Adding 2 columns

i just want to add column 2 to column 1 if and only if column 2 has just 1 text character in its cell .enter image description here
user avatar
1 vote
1 answer
40 views

Using one table to update another in Excel?

Let's say I have a table with two columns. The first column is a list of email addresses. The second column is a list of dates--let's say appointments. Each month I receive a table with updates, which ...
user avatar
  • 11
0 votes
1 answer
128 views

How to automatically sum columns datas of a grouped row subset with common attributes (excel csv spreadsheet)

I have a big csv file (one million rows) I imported in excel. I have to do a simple operation, easy to be done manually, but I should do it for thousands groupings so I am looking for an automated ...
user avatar
  • 3
0 votes
1 answer
23 views

How to FIlter/Match spreadsheet data based on two row headers?

I need to find a value based on a specific column and header, that also fall within another merged header (spans 3 cells) like the example below: |January 2020 |February 2020 |...
user avatar
  • 239
0 votes
0 answers
36 views

How to VLOOKUP based on two column criteria?

I'm not exactly sure if this calls for a vlookup, but it's the closest I could think of to solve the following scenario: Animal|Color|Total ------------------ Cat |Red |150 Cat |Blue |85 Cat |...
user avatar
  • 239
0 votes
1 answer
38 views

How can you format each row from a pivot table to display transposed with the headers repeating themselves?

From a pivot table, I am attempting to take each row of data and format it transposed with the headers from the pivot table present in each instance. Here is a link to a Google Sheet that has a sample ...
user avatar
0 votes
1 answer
72 views

How to highlight cells with duplicate values using Excel's inbuilt Conditional Formatting rules, specifically to compare `<` or `>`?

OS: Windows 10 Pro Version 20H2 (OS Build: 19042.1165) Application: Microsoft Excel for Microsoft 365 Version 2107 (Build 14228.20250) When using Excel's inbuilt Conditional Formatting rules to ...
user avatar
0 votes
0 answers
31 views

Numbers: How to add or subtract hours for a column with date-time value?

Please note that this questions is about Numbers and not Excel. Givens: column x has values of format yyyy/mm/dd hh:mm column y has empty values Desired solution: column y to have values from column ...
user avatar
  • 1
0 votes
0 answers
25 views

how to compare 2 columns and if the value in A is higher than B, copy the value of A over B

I'm trying to compare 2 columns of similar data and would appriciate some help. i need to know how to do the following. I what to know how to compare the values in column A with column B, then if the ...
user avatar
  • 1
0 votes
0 answers
44 views

How to bring sum of previous column in to next column automatically, in Excel or Google Sheets?

I'm new to this. I'm trying to make a personal budget sheet, where I can bring the previous months' sum into the next month's column as "savings from last month". Basically I want to show ...
user avatar
  • 145
0 votes
2 answers
74 views

Excel SUMIF/SUMPRODUCT with Dates Identifier?

So I am currently working with a spreadsheet of data that has info on a set of loans and how they payback over time. I'm trying to create a table that sums their payback based on what month they were ...
user avatar
0 votes
3 answers
43 views

Microsoft Excel - Rolling Average with Skips

I have a table of costs among several different locations for the past x years. For each location (A, B, C), I would like to find the average cost of the past three visits. Unfortunately, locations ...
user avatar
0 votes
1 answer
55 views

How to Calculate the Average after a certain date

Im trying to get the average of days taken to send to college but i only want it to take in to consideration dates received after 17/05/2021. can anyone help
user avatar

1
2 3 4 5
13