.tableizer-table

  1. A

    Divide Arrays

    I have 2 Arrays each located in a cell. I would like to divide the first one by the second one. Please see below. <tbody> Array {0;1;0;1;0;0;1} {0;1;2;2;0;1;2} </tbody> <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ...
  2. muhammad susanto

    Insert 3 Number Zero (000)

    hi all.. how to inserted 3 number zero (000) in a data like this : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px...
  3. muhammad susanto

    Extract Data Only Roman Number

    hi all... how to extract data contains roman number like this : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; }...
  4. muhammad susanto

    Data Validation With Unique Drop Down List

    hi all.. i have the data this below : <thead> Group Class Type </thead><tbody> Inner I Arteri Inner II Arteri Inner IIIA Arteri Inner IIIA Kolektor Inner IIIB Kolektor Inner IIIC Jalan Lokal Outer I Arteri Primer Outer I Kolektor Primer Outer I Arteri Sekunder...
  5. muhammad susanto

    Counting in Different Data Repeated

    hi all.... how to counting data this below , different name this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid...
  6. A

    Sumifs Help - Payroll Planning

    See the table below, I'm looking to calculate available hours in Col D. the SUMIF statements for the FT and PT statuses are straightforward. Looking for help on the date conditional in regards to 'Seas' Status. If the status is 'Seas' I want their Hrs Avl added to the total Available hours...
  7. muhammad susanto

    Sorting Data Not Work

    hello all.. i try to sort data asc to desc but not working , how to fixed it.. <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px...
  8. muhammad susanto

    Fill Series Number With Criteria

    helllo... i am looking formula to fill series number based on adjacent with basic count of data 3 cell like this : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding...
  9. C

    Collect Tab information to create a main list

    I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the...
  10. C

    Collect Tab information to create a main list

    I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the...
  11. muhammad susanto

    Fill Series 1,2,3,1,1

    hi all.... how to make series like this : <tbody> data expected result jack 1 2 3 cat 1 dog 1 etc.. </tbody> note : without helper column any helps...greatly appreciated... susanto.
  12. muhammad susanto

    Extract To Be Nick Name With Initial in The last Word

    hi all... how to extract this text to be the nick name like this : <tbody> name expected result PT. DHARMA BERKAH SERINDIT PT. DHARMA BERKAH S PT. HALMAHERA KAYU PT. HALMAHERA KAYU KOPERASI PETANI SAWIT MERANGKAI SEJAHTERA KOPERASI PETANI SAWIT MS PT. INDO PATRIA PERTIWI PT. INDO...
  13. A

    Run Time Error 462 when copying and pasting Tables VBA

    Hello, I am having an issue with my code, I am trying to copy 3 different locations within Excel and then Paste those values/tables within Word. I keep getting a Run Time Error of 426. I tried looking up what this could mean but I am having no luck. I have been driving myself crazy...
  14. F

    Formula to match the closest value and get corresponding description

    Hello, <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; }...
  15. S

    VBA Areas Highlight that do not have certain values in them

    Good afternoon, Please see data below. I am looking for some VBA code that will highlight an area if it does not have a value in it. In Column E if the first 2 Alpha characters do not start with "MA" or "EN" then highlight the area, if not leave blank. <style type="text/css">...
  16. M

    Weird Sum DAX help...

    Hi Team, Looking for some DAX to achieve the following... Data as follows: <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid...
  17. A

    VBA Pull out Currency from string

    I have about 150,000 rows of data. What I am looking to do is to pull out the currency to the cell next to it. The data is formatted like below: Please help. Thanks again! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ...
  18. muhammad susanto

    Insert Number in Between String

    hi all.. how to insert this number 5 digits <thead> entry expected result </thead><tbody> 1 LPK-00001/1/1/WKN.03/KNL.03/01.00/2018 15 LPK-00015/1/1/WKN.03/KNL.03/01.00/2018 326 LPK-00326/1/1/WKN.03/KNL.03/01.00/2018 </tbody> any helps..thanks.. m.susanto
  19. M

    Supply frequency measure...

    Hi Team, Looking for some help to do the following... Data as follows: <tbody> Week Product Supply 1 Apple 0 2 Apple 0 3 Apple 0 4 Apple 5 5 Apple 0 6 Apple 0 7 Apple 10 8 Apple 0 9 Apple 10 10 Apple 0 11 Apple 0 12 Apple 0 13 Apple 0 14 Apple 0 15 Apple 5 16...
  20. M

    Extracting records for max sales per product...

    Hi Team, I'm looking for help with Power Query to achieve the following... Here's my data: <tbody> Product Type Sales Apple Bag 11 Apple Box 4 Pear Bag 7 Banana Bunch 8 Orange Bag 12 Orange Box 4 </tbody> I want to extract the records for each Product where the biggest Sales...

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