1px

  1. V

    Input Text in RTE (iFrame) is becoming null after page refreshed/saved - VBA Macros

    Planning to create a Test data (i.e. Record) for my Project. As part of it, trying to create a Test data by automating Web application through VBA. I am able to enter/input data for all the fields including (RTE - Rich Text Editor), once the page is refreshed/Saved RTE input data becomes null...
    • Vino22
    • Thread
    • .cke_show_borders 1px cke_show_blocks dotted table.cke_show_border
    • Replies: 0
    • Forum: Excel Questions
  2. 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 ...
  3. muhammad susanto

    Rank From Number

    hi all... how to make rank this layout below : <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...
  4. 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...
  5. muhammad susanto

    Extract Data After Last Space

    hi all.. how to extract data below after last spaces 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...
  6. muhammad susanto

    Fill Series Number Based On Adjacent Cell or Column

    hi all... how to make fill series number based on adjacent column 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...
  7. 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...
  8. 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...
  9. 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...
  10. muhammad susanto

    Conditional Formatting Formula To Fill Red If Number Nearest Zero

    hi all... how to make formula in Conditional Formatting : to determinate fill cell red color for number that nearest zero (absolut number) this layout : <tbody> data1 data2 data3 -10% 39% -46% </tbody> any help thank in advance... .sst
  11. 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...
  12. 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...
  13. muhammad susanto

    Lookup From Partial Number (From Left)

    hi all... how to lookup data with partial match count of 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...
  14. muhammad susanto

    Custom Number Format (2.01.01.03.02.2)

    hi all.. how to make this layout using Custom Number Format : <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. 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.
  16. 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 ; }...
  17. 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">...
  18. 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...
    • Matty
    • Thread
    • .tableizer-table 1px dax solid
    • Replies: 2
    • Forum: Power Tools
  19. 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 ...
  20. M

    Weighted average DAX help...

    Hi Team, Looking to replicate the following in DAX... Here's an example table in Excel to paint the picture: <tbody> Key Figure UOM Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Average Weight PUMs 4,011,692 4,186,301 3,610,294 3,413,225...

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