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

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

Hello i try to find most match row # in a array formula i have 2 sheet with same coloms name like i post down i make a formula like Po sheet 1 = all PO row in sheet 2 and qty sheet 1=all Qty in sheet 2 and its give me true and fales in array so i want to get the row # of whre most true like row...

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

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.

hi all.. how to make sequential number with parameter my target in column "interval" and "given" number as parameter (based on) like this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial...

I have been struggling with this for a while. Is there a way to sum data without having school names all of the way down Column A. I get a lot of data like this and I have to go back and fill in the schools to used Sumif or Sumproduct. I would like to find a way to do it without filling in the...

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

Good afternoon, I have data that is pulled from a program that has different headers but those headers are alike. For example Bereavement Immed and Bereave Near Relativ they are one in same. I need to sum and consolidate those to 1 field. Personal w/Approval and Personal W/OApproval are one in...

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