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

0
votes
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
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
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
1answer
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
2answers
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
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
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
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 ...

153050per page