solid

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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