efg

  1. S

    Running Numbers Formula

    hello. Hope You will be Fine. My Question is that I Create a Table That Has Column as below ID NAME CITY AD-01 ABC UVW AD-02 EFG XYZ (????) <--Here i want the formula that change the only NUMBERS not TEXT automatically. e.g. AD-03
  2. F

    Countifs with partial match

    I need a countifs column that will count values in columns that contain the words TA2 and EFG. The column headings are something like "2019: Year 11 TA2 (22 Jan 2019): Mathematics: EFG" So I need to count any value where the column that contains the words TA2 and EFG and the student has a...
  3. J

    Vlookup with retain cell format

    Dear All I have a question, may i know how to use vlookup with maintain the cell format like Bold, Italic. eg; <tbody> Data A efg 123 B efg 456 </tbody> when using vlookup formula, all format will gone. Can you provide solution
  4. F

    VBA: Insert 2 columns if header matches

    I need to insert 2 columns if the header contains "*FFT Target". I've found this code, however, it does not move on to the next column containing "FFT Target" but inserts the two rows before the first column where the heading matched. Sheet headers I currently have are: <tbody> English FFT...
  5. B

    CountIF Formula Help

    hello i have a sheet that looks like below layout with unique identifiers in the columns. Looking for a formula to help tell me how many of each identifier there is. for example results would be ABC=2 BCD=3 EFG= 7 Note some columns could be blank, not sure if that impacts anything..ty <tbody>...

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