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.

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
11 views

Spreadsheets: How do I only select non-empty cells in function?

I use this function to find a random content of a cell: =index(A3:A100, randbetween(1, counta(A3:A100) ) ) Some of the cells in A are empty. How can I change this function, so that only those cells ...
0
votes
0answers
3 views

How to show linked picture when I click on a cell

I'm currently working on an Excel project where its required to show a table whenever I click on a cell in another sheet much like how a comment box works. Should look like a floating table
0
votes
0answers
30 views

Excel Online can't see other people's selections

I found this on microsoft's website: Why can’t I see other people’s selections? You can see other people's selections in different colors, but only if you and other people are using Excel for ...
0
votes
0answers
14 views

how to visualize time range data in google sheets

i have several thousand rows of data. Each row represents a task and includes the start time, end time, and data related to the task in the other columns. A task duration varies between 1 second to ...
0
votes
0answers
8 views

Excel Sorting Help

I have a large amount of data that needs to be sorted by number and then analyzed. Is there an easier/faster way than sorting all this data into separate sheets in excel? EX: I'm looking at breaking ...
0
votes
0answers
64 views

How do we determine shape parameter of a Weibull plot using Google Spreadsheet?

I have a spreadsheet with time to failure data that follows the weibull distribution. The slope from the plot of time-to-failure and median-rank gives me the scale parameter. Is there a function to ...
0
votes
0answers
16 views

I have a specific excel list of emails that I would like to apply gmail filters to

I have an excel file of emails and I was wondering if it’s possible to get add gmail filters to the excel spreadsheet so that anytime a certain emailer emails me it will go straight to that gmail ...
0
votes
0answers
7 views

Creating two horizontal axis labels for the data points in excel?

See graph below: I would like to add the wavelength as a second horizontal axis below the frequencies. For example, Frequency 4 (x10^14) corresponds to 750nm, frequency 8 (x10^14) corresponds to 370nm....
0
votes
0answers
29 views

How to compile sets of cells with a formula in Excel?

I have a spreadsheet with specific sets of cells that I would like to be able to just tick a checkbox (or something similar) which ones I need to make a one full set on a main sheet. Example (width/...
0
votes
0answers
301 views

Regex Matching for Google Sheets Query Formulas

I'm trying to return a limited list of cells using a query that references another tab in my Google Sheets book. Please find a sample book here. The returned cells represent social media posts -- I'm ...
0
votes
0answers
20 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
133 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 ...
0
votes
1answer
353 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
340 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
847 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. ...
-1
votes
1answer
25 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 ...