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

**0**

votes

**0**answers

10 views

### Compare sequentially Coma Separated Values from two columns and give matching values - Help Needed

Hi I have a challenge where I have to compare the coma separate values from 2 columns (Column A , Column B and find the sequentially comma separated matching values and output to Results column....

**0**

votes

**0**answers

13 views

### match columns from two sheets and return row entries

I have this work book with two sheets "main" and "team". What I am looking for is if column 'leaders' in the 'main' sheet has value 'yes' then first_name and last_name must be concatenated, so that ...

**-2**

votes

**0**answers

29 views

### Stock auto update in excel [on hold]

I want to calculate Stock with Sale and Purchase product. When my sell and purchase cell will be update then auto calculate in last stock cell.For first time it is ok but when i put another value in ...

**-4**

votes

**0**answers

45 views

### I need an Excel formula with three conditions or multiple criteria

I need a formula that will...return "LEVEL 1" if value is <100,000;return "LEVEL 2" if value is >=100,000;return "LEVEL 3" if value is >=1,000,00 PLUS it meets the criteriaof cell 2 which is >=...

**0**

votes

**0**answers

36 views

### Excel: How to list out matching items in a single cell

So, I have a list of Chinese characters. When I hover over a character, I would like a pop-up box to display showing me all the entries in a separate list which contain that character somewhere in it. ...

**-1**

votes

**1**answer

59 views

### Total Count by Group

I'm trying to get a count by group, "group" meaning a consecutive collection of rows where Charge (column B), is either 0 or non-zero. In the example below, the column named Results is what I'm trying ...

**1**

vote

**1**answer

26 views

### Date and closest time continuous glucose monitor

I am a diabetic I can export my continuous glucose monitor blood sugars in to excel sheet, this machine checks my sugars every 5 mins. What give my doctor are snapshots thought out the day. Its ...

**0**

votes

**1**answer

21 views

### Excel - How do I count instances of by counting the assigned value for each cell entry?

Okay, I know that the title of my question is terrible, but I'm rather new to Excel and I frankly don't even know if what I want to accomplish is possible.So I want to create an Excel spreadsheet to ...

**0**

votes

**0**answers

35 views

### Excel conditional formatting using formulas

I have two conditions that I would like to format. The conditional formatting commands will go in a macro that will be used on a weekly report. The number of rows in the report will vary from week to ...

**0**

votes

**1**answer

21 views

### Update Content within Cells in Excel sheets using specific format

My excel sheet has columns with value like RootUser*UK\abc.def*def, abc*-*https://website.xyz.com/sites/123*And I want the format to be <Mapping Source="UK\abc.def" Target="i:0#.f|membership|...

**0**

votes

**1**answer

22 views

### Excel Aggregation function on arithmetic combinations without temporary column?

I often want to do aggregate functions on linear combinations of columns without having to create a new column to hold the linear combination. Is there a way to do this?E.g., if my sheet has data ...

**-1**

votes

**0**answers

27 views

### How do I concatenate similar data from a column into a single cell? [duplicate]

As shown in the above image, if cells in Column C have a common category (Column B), the cell data needs to be concatenated and placed next to parent category as shown in cell H3. I can do it by ...

**0**

votes

**1**answer

99 views

### Calculate average number of days between two dates for unique fields

I need some help with a single formula in finding unique tasks and then getting the average between two dates. Looking at the below example:Task Closed &...

**-2**

votes

**0**answers

71 views

### how to vlookup and return multiple values

Hoping someone can help. FYI the original thread/code can be found here: Excel - How to vlookup to return multiple values?I'm looking to use Excel to look up and return multiple reference values for ...

**1**

vote

**1**answer

18 views

### How to have Excel Auto Populate Data from a Table when an Option from Drop Down Box is Selected?

I am trying to create a form in Excel that auto-fills data when a certain selection is chosen from a drop-down list.I have the table:Apple | Red Orange | Orange Banana | Yellow ...