solid

  1. S

    Count Areas with a formula

    I am trying to count areas with a formula. Please see below. Thanks in advance! <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...
  2. S

    Counting Asterisks

    I am trying to count Asterisks in my data but to no avail. <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 ; }...
  3. S

    Counting Columns of x

    I have been racking my brain. I am trying to get a formula to count columns that contain an x. If it does I only want to column to be counted as 1. For the example below I want a count of 5. Thanks in advance! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px...
  4. K

    How to find and SUM Multiple Column Data by two criteria?

    <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 ; } .tableizer-table th { background-color: #104E8B ; color: #FFF...
  5. M

    Can MDX be used for this?

    Hi Team, I have a Pivot Table report linked up to a data model held in the Power BI Service. OLAP is used for fast querying. I now need to present some of the data in a slightly different way and I'm wondering if MDX (in Excel) might be the solution. Below is small example to try to...
  6. A

    VBA Count add to Sheet2

    I have about 40,000 rows of data on sheet1 like below. What I need to do is to give a summary of grade level on sheet2. Please see below data. <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica...
  7. muhammad susanto

    Make it mark "V" if found mark "X"

    hi all.. how to make formula to determine mark "V" (checklist) if in a range e.g range D3:I6 found mark "x" my "x" in always in different position cell (random) like this layout : <tbody> given given given given given given x test1 test5 test9 test2 test6 test10 test3 test7...
  8. muhammad susanto

    Clustering Number Then Convert in "Model"

    hi all.. how to clustering this number below then convert in "model" like 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 {...
  9. muhammad susanto

    Counting Data "Sold" Ignore Duplicate Number

    hi all.. how to counting data only "sold" but ignore repeate or duplicate "number document " like this : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table...
  10. CsJHUN

    Summarize table

    Hi Gals and Guys, let say i have 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...
  11. S

    VBA highest grade per row

    I am trying to get the highest grade per row with VBA. <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 ; }...
  12. muhammad susanto

    Vlookup with 2 Criterias

    hi all.. how to lookup data with 2 criteria: this layout <tbody> year name score 2017 johny 100 2017 andy 150 2017 mike 200 2018 johny 300 2018 andy 400 2018 mike 600 </tbody> year 2017--johny ---? 2018 -johny--- ? any help, thanks in advance.. .sst
  13. muhammad susanto

    Delete (.) Then Combine 3 Last Number With Mark (-)

    hi all... how to modify 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; margin: 3px; border...
  14. muhammad susanto

    Check if Fomula Error

    hi all.. i'm looking for formula to check or show if error this table: <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...
  15. W

    Return Related URLs into one string (Textjoin)

    So I have a list of URLS and I need to return all the related ones into one string. The urls are laid out in a logical manner Domain / directory / sub-directory / In theory this should work, but I'm getting some random urls in there. I just want any url that contains the group slug none others...
  16. muhammad susanto

    Convert Text to Real Number

    hi all.. would you help me to figure out this problem. i want use formula to solved it.. <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td {...
  17. muhammad susanto

    Custom Number Formula to Make Adding Mark "." (Dot) Between 2 Number

    hi all... i need your help to figure it out this problem use Custom Number Formula <thead> entry expected result </thead><tbody> 11 1.1 23 2.3 41 4.1 32 3.2 </tbody> any help greatly appreciated... sst.
  18. S

    VBA Count above values below.

    Good morning, I need help with some VBA. I have about 350,000 rows of data. What I am trying to do is to put the actual count above the numbers they are counting. Please see below. Thanks in advance! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC...
  19. muhammad susanto

    Adding Mark "-" Between Number from 2 columns

    hi all... how to adding mark "-" between number from 2 columns (joined) 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 {...
  20. K

    Yearly attendance sheet_Need help

    Hi All, I want to make a yearly attendance sheet. From the below table I need the formulas for followed conditions. 1. Every month Casual leaves should be added (2 casual leaves every month) based on Month into Casual L colomn. Example: for Jan-19 K3 should be 2 based on today date. 2. 2019...

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