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
24 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&...
0
votes
0answers
24 views

Can I exclude the bottom row from a Filter in Google Sheets?

I have a spreadsheet in Google Sheets, there is a header and 13 rows containing data. There is then a row containing the average of the cells above. I'd like to be able to sort the various columns in ...
0
votes
0answers
12 views

Excel Text, Number, Variable Deliminator Split using VBA

I have a very large work request data set that I need to clean up. The data set has some consistent elements there are a series of numbers that are a set length this is changes about about half way ...
0
votes
0answers
8 views

Data validation

Two separate workbooks: the 1st workbook - Has Customer Data - Name, Address, Contact etc. the 2nd is an invoice which as cells to add the Customer Name etc What I require is to extract data from ...
0
votes
1answer
25 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
0answers
41 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
30 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.
0
votes
0answers
9 views

Formula Parse Error in excel

=[20150*(.036/12)*(1+(.036/12))^60]/[(1+(.036)/12)^60-1] This is the formula I am putting in excel and it won't work. The correct answer is 367.4667 Can someone please help, everytime I type this ...
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
1answer
561 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
576 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] ...
-1
votes
1answer
9 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
votes
1answer
19 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
26 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 ...