solid

Hello, I am trying to find some gaps in a set of numbers. I did find this video (https://www.youtube.com/watch?v=_jel_Otcgds) however it did not work for my set of numbers. possibly due to how the numbers are formatted. These numbers are formatted using a custom format field. I have listed...

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">...

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...

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 ...

Hello, I need to make a graph for a set of data shown below <tbody> 20 degrees Liquid 40 semi liquid 60 semi solid 80 solid 100 solid </tbody> I have tried countless different methods and cant find a way. The right hand column needs to be on the y-axis. Cheers for any help OldBirch

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...

hi all.. how to make series alphabetically based on unique adjacent cell... <thead> order/desired data </thead><tbody> A apple B apricot C banana C banana D apricot D apricot D apricot etc.. avocado blackberry blackberry blackberry </tbody> my target...

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

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...

Good Morning, I have about 90000 rows of data. What I need to do is to make 1 line of data based on Column A and B on Sheet 2. Thanks in advance. <style type="text/css"> table.tableizer-table { font-size: 8px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; }...

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...

hi all.. how to make this use 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 ; }...

Good morning I have a large data set approx 100,000 rows. I need to sum and combine the data based on Emp ID and DEPT only if they are the same. If the Emp ID and DEPT are not the same then leave it be. There will always be a Cur or Re in Column (S) The data must be Combined and summed in Cur...

Hiya. I am having fun learning this vba stuff! But, I'm stuck. My Book contains businesses and address info, like this: <style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal...

hi all... how to fill/joint data based on header clue : <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...

I have a set of data that was given to me about 100000 rows like below. What I need to do is to count the areas but I can't figure it out. Any help would be appreciated! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial...

Hi Team, Looking for some DAX help again! Here's a mock up built in Excel to illustrate what I'm trying to achieve (data resides in range B2:K23): <tbody> Product Key Figure 18/12/2017 25/12/2017 01/01/2018 08/01/2018 15/01/2018 22/01/2018 29/01/2018 05/02/2018 Apple Demand 5 56 45 6 25 50...

hi all... how to adding 0 and mark "-" without helper 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 solid...

hi all... i have problem how to make data validation list/formula with multiple criteria <tbody> City Model Type Inner City I Arteri Inner City II Arteri Inner City IIIA Arteri Inner City IIIA Kolektor Inner City IIIB Kolektor Inner City IIIC Jalan Lokal Outer City I Arteri...

Hello, I am naveed, this is the first time ever i am writing on a web portal for help. I hope this works out, below mentioned is my query. 1. Imagine below is the data that we have in Sheet 1 <style>table { }td { padding: 0px; color: black; font-size: 12pt; font-weight: 400; font-style...