Hi All, looking for someone to help me out with this, as i haven't got a clue myself!
Here's the screenshot of the excel sheet.
For my work we have primary and QC work in which someone working on Primary, shouldn't work on QC side within the same "Program Name". Essentially what i want to do...
Column F:
i have used drop-down list and below code to get two values in one cell, >>>>>>>
Private Sub Worksheet_Change(ByVal Target As Range)
'Updated by Extendoffice 2019/11/13
Dim xRng As Range
Dim xValue1 As String
Dim xValue2 As String
If Target.Count > 1 Then Exit Sub...
Hi,
I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved.
I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
All,
I need to show clients in a pivot table according to two criteria.
Here is the raw data
<TBODY>
Client</SPAN>
type</SPAN>
Region</SPAN>
client A</SPAN>
Bank</SPAN>
East</SPAN>
client B</SPAN>
Fund</SPAN>
East</SPAN>
client C</SPAN>
Broker</SPAN>
East</SPAN>
client...
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.