solid

Hi, I have a file that I do a summary about different items (SKU) for a given entity for the current period (February in this case) and a YTD. For the monthly one, the formula is a sumproduct based on the entity, SKU and period (201902). Is it possible to have one that's cumulative? For now I...

Good evening, I am looking for VBA to do some unique counting for me. I have over 200000 rows of data. The formula approach I have been using is below. But I really want to automate to VBA. {=SUM(IF(FREQUENCY(IF(($A$2:$A$22=F2),$B$2:$B$22),$B$2:$B$22)>=1,1))} <style type="text/css">...

Hi Team, Looking to understand how others would tackle the following task... Here's a very simple example of my data set: <tbody> Version Month Forecast A Jan 10 A Feb 3 A Mar 8 A Apr 5 A May 3 A Jun 7 A Jul 8 A Aug 1 A Sep 10 A Oct 9 A Nov 3 A Dec 4 B Jan 4 B Feb...

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

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Georgia, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-family...

Hi, I am looking for a VBA solution to check to see if every value in the row is the same. I am trying to learn. If the row has a blank cell then the row is not the same. When it finds it please put an x at the end if the row. <style type="text/css"> table.tableizer-table { font-size: 12px...

hi all.. how to make in custom number format e.i <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...

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

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

New user here in need of help. I am creating a mixture design using 3rd party software and needhelp setting up the constraints. I’m using Excel to do the math and willput it into DOE software. What the DOE softwaredoes is it looks at the high and low ranges that you enter, and it...

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

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

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

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

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

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

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

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

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

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.