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

**0**

votes

**0**answers

5 views

### Excel: Getting FALSE, when the value is in the row array

I have a table where I want to pull data based on the row and column labels. So I'm using the INDEX MATCH with arrays in the MATCH function but I keep getting a #N/A because C1:K1=K1 is FALSE. Why is ...

**1**

vote

**1**answer

21 views

### Is it possible to hide a sheet using excel formula

I have a scenario to hide the sheet based on the cell's value. Using the macro below I can able to achieve this.Private Sub Worksheet_Change(ByVal Target As Range)If [G1]="Yes" ThenSheets("...

**0**

votes

**0**answers

12 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

20 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

53 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

49 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

47 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

71 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

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