array a value

  1. D

    Split and search for values in cell

    Good Morning I wondering if its possible to create a formula that would split a cell by a comma and keep only the values that start with "TV -". Keep only unique values Take the data and insert a line feed between each grouped value before saving it to the column as shown in the...
  2. U

    VBA: Delete Entire Columns based on Header value in Excel

    Hi Gurus, Good day! I found below code in deleting specific column. However, I want to apply it for all tab sheets. Suppose I have 15 sheets. = = = Sub DeleteSpecifcColumn() Dim xFNum, xFFNum, xCount As Integer Dim xStr As String Dim xArrName As Variant Dim MR, xRg As Range On Error Resume...
  3. L

    Dynamic Chart to show the range based on the condition

    Hi Guys, I have created a clustered column chart and scattered chart to show the market rate and the actual rate as shown below. Now for each job titles with location I have been manually looking for FTE, Terms value by inputting respective values from the data stored in 'Inputs' sheet...
  4. L

    Developing an Array Function that Gets all the Worksheets Name property with Conditions

    Guys I would like to develop a function that can retrieve/get the Worksheet names from the current workbook as an array function. The criteria is only Visible WorkSheets and the name <> "Setup". I tried the code below but it is NOT working properly Can you guys help me Public Function...
  5. S

    Lookup Value in Range and return nearest number (lowest) beween sets of numbers within the range

    <tbody> Challenge 1: What you know: The employee is in pay grade 3 and rate is $25.30 Challenge: write a formula that looks up the grade, and then returns the value on that range in which $25.30 is nearest to (rounded down) Challenge 2: Write...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top