scc

  1. B

    Creating a dynamic range using Index

    I'm using the index match formula as my lookup formula: INDEX('All SCC Ready to Import'!$A$2:$A$800,MATCH('LocalStateSCC Falcon Positions'!H30,'All SCC Ready to Import'!$E$2:$E$800,0)) I would like to make this lookup dynamic without having to change the range from A2 :A1000 for example. I...
  2. B

    Ppulating cells where adjacent cells are empty

    I have a spreadsheet where I am trying to populate positions from a lookup table on another sheet (LocalStateSCC Falcon positions) where all the source positions are in a single column. I have a column for Local, a column for State and a column for SCC in my destination sheet (the one which...
  3. B

    Converting First part of string to Proper

    I have a situation where I have a string with two words in it that are all upper case that I'm running in a query. I want to convert the first word to Proper Case but leave the Acronym as all caps. For example, I have the Term "ALCOSTA SCC" but it should be "Alcosta SCC". I also have other...

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