Questions about using in-cell functions/formulas in spreadsheet software.

0
votes
0answers
9 views

Excel ISBLANK IF Formula

So far I have this but will not work=IF(ISBLANK(AJ17:AM17),"",IF(AD17=0,"", AD17))What I want to happen is...If Cells in a row AJ through AM are 0 or Blank then do not show Price from Column AD in ...
0
votes
0answers
19 views

How create a nested drop down in Excel?

Basically, the drop downs consists of:Region - Independent from OthersProvince - Drop Down that depends on Region with reference with Region IDMunicipality - Drop Down that depends on ...
1
vote
1answer
52 views

Excel: How to delete all text to the right of specific string

I have a bunch of web sites in a list, with junk characters after the .com/.org, etc. I need to remove all characters after the .com/.org, but keep the .com/.org. For example: these sitename.com - ...
0
votes
1answer
22 views

Excel formula with 3 conditions and three outcomes

Let me start off by saying I am not an Excel expert. I have been able to figure out most of the formulas thru research and trial and error but this one has me stumped. I need a formula that does the ...
0
votes
0answers
6 views

Microsoft Excel Pivot Table Display Control

I have an active, changing daily, SharePoint data set that I have linked to a macro enabled Excel 2010 spreadsheet. It pulls in the entire data set every 2.5 hours. There are a total of 57 data rows, ...
0
votes
1answer
27 views

Get the topmost value from the second column for each unique id in the first column in excel.

I have a sheet in excel with the data in columns A and B set out like this. I have data in other columns as well, but I just need the values in A and B. The data in the columns look like this. A ...
0
votes
0answers
11 views

Create Histogram of Excel Cell Groups greater than Certain Value

I have a long column of data, in which I have peaks of variable length. I would like Excel to give me the number of these "groups of cells" and also tell me how many cells they consist of. In this ...
1
vote
1answer
47 views

F&B Industry - How to convert 1 Menu into its components with Excel?

I work in F&B industry and I have a problem that my company software could not handle, so I try to manage it in excel.I have a menu that has many components within.So I try to convert the menu ...
0
votes
1answer
44 views

how to cut data in excel using formula?

i use ms excel 2007i want to cut a row in sheet 1 then paste it to sheet 2 using a formula in exceli have already used=VLOOKUP or=A1 but it is only copy the data and not CUT itthanks for all ...
1
vote
2answers
66 views

Is it diagnostic for an Excel function wizard to work but not manual entry?

I'm hoping someone with knowledge of Excel's inner workings can shed light on a strange Excel issue. I helped someone with an Excel problem, and the solution involved using the TEXT function to ...
0
votes
0answers
7 views

MAC Book Pro using Excel for MAC Version 16.12

When I type a number or letter (the “Data”) into a cell (the “Original Cell”) and then press enter the cursor, the Data jumps down to the cell in the Row below [but in the same Column]. The Original ...
0
votes
1answer
77 views

How to combine data and calculate in Excel with formula

Please find attached mention 3 sheets with same headingSection ID item count amt gross amtSheet 1 and sheet 2 need to add together for whatever matching section and ID column, Need to add ...
-1
votes
1answer
33 views

Copy cells from one excel spreadsheet to another based on a value in the row

I have a spreadsheet, Sheet 1, with data in it taken by the minute. Each line row has a timestamp and the corrosponding data follows.I have a second spreadsheet/sheet, Sheet 2, with accompanying ...
-3
votes
0answers
50 views

Find Missing Values and copy to cell [on hold]

Working in Excel. I have a list of work orders that in a column that I want copied only if they are not also in another list so I can quickly find order #'s that were not scheduled. I need a formula ...
0
votes
1answer
70 views

Excel issue with “=TODAY()” and adding it to another cell with other values

As you can see below I'm unable to get the=TODAY() "correct" information over to another column. And I'm really hoping that there is some way to actually get this to work.I'm fairly new to excel so ...
0
votes
1answer
41 views

Convert cell reference to text in Excel

I am trying to extract data from another sheet in an Excel file. The sheet name is stored in a cell.This is the equation so far:=INDIRECT("'" & $A$33 & "'!" & "C4")The sheet name is ...
0
votes
0answers
30 views

Take values from multiple closed Excel files

I'd need to create a list with values taken from various closed Excel files, all named with numerical value (001, 002, 003...). The numbered workbooks all have the same format, so the position of the ...
0
votes
0answers
23 views

Excel 2010 - match value to a group of several values [on hold]

Goodday,Don't know why this is getting on hold. It will not get more specific than this.As an accountant, this is a puzzle that we are facing on a daily basis. As long as I know, everyone does ...
0
votes
0answers
32 views

Excel: Graphs which appear only conditionally

I have a rather complex data set and the first column is composed of Booleans.I want to plot data from each row in a separate graph - but only if the first cell in that row is TRUE. Preferably, this ...
1
vote
2answers
34 views

How to substitute FALSE with N and TRUE with Y in one column

What formula can I use in an Excel column where I want FALSE to be N and TRUE to be Y? Data is imported from SharePoint Task List to Excel for a project completion report. Thanks
-1
votes
2answers
22 views

Several exclusion criteria SUMIFS Excel

Here is my Excel table:Apple 5Apricot 3Avocado 8Banana 10Bilberry 3Blackberry 2Blackcurrant 15Blueberry 2Boysenberry 7I would like to sum everything except Banana and ...
2
votes
1answer
44 views

How to find a nearest number to average

I have a sample like this where I want to find nearest value to averagecity and weight are two separate columnscity weightA 23A 22A 45A 97B 34B 22B 23C ...
0
votes
1answer
18 views

Excel - moving data for duplicate rows to new columns

I have duplicate rows which represent customers who have bought different items. The item purchased are in one column. I would like to move them to separate columns so that I can import to a different ...