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.

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

Dynamic calculation of what one cell value would be if another cell (used as input for range) had a different Value

I have a spread sheet with an itinerary containing itemized day to day travel. On the sheet there is a large range accounting for variable costs, in which a specific cell (We'll call it K10) says how ...
0
votes
0answers
32 views

Preview Excel file attachments in Google Mail (cell format settings)

When I open a preview of an Excel File I got as an attachment in Google Mail, Google changes all the date formats to "US style" MM/DD/YYYY although the original file uses "German format" DD.MM.YYYY. ...
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
34 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
19 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
76 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
20 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
35 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
1answer
405 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
414 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
980 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 ...
-2
votes
0answers
24 views

COUNTIF/COUNTIFS

I am converting an excel sheet into google sheet but the formulas aren't translating as I'd hoped. Below is a formula I use which basically counts the people i have on shift per day. =COUNTA(R7:R10)-...