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

**0**

votes

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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 ...