border

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

Hi All, I have a pivottable with multiple items in the column section. I have tried modifying the pivottable using the Pivottable styles editor but can't seem to get what I want to achieve to work and would appreciate any advice I have put a picture below with two examples (with made up data)...

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

My border won't appear. What setting do I need to change to get a border appearing?

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've highlighted certain cells with a Thick Outside Border and have the cells colored. When I sort the sheet the data and the color move but the Thick Outside Border remains fixed. how do I get the border highlighting to move with the data? thanks

Hi all, I'm using excel 2016, and when I create a text box and fill the box with background color, towards the right of the text box there is an awkward line (it's not the border). It's in every text box I create and fill, and the line is always about 0.8mm from the right border of the...

hi when i press save button , my value pastet to sheet "data" With border i want past to data sheet without any border , just value download file : https://ufile.io/ql5uk Sub Rectangle2_Click() z1 = Range("B5").End(xlDown).Row z2 = Sheets("Data").Cells(Sheets("Data").Rows.Count...

In Column B is a concequtive list of numbers from 1000000 to 7000000. Want to insert a underline border in column A to H the first time the number is above 3999999. (This is part of a vba formatting mode) Column B is a list of account numbers. Not sure the specific account 3.999.999 exists...

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

I'm trying to customize my toolbar with a button that sets the borders of a cell(s) to thin/grey. To start, I use Format/Cell to set cell border color to grey, thickness to thin, click all the borders. Then.. View Toolbars Customize Commands Format And dragging the Border button to my toolbar...

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

Hey, So basically I have an excel-workbook where the background is colored light grey and there is a table with "normal" black borders and one thick black border under the top row. When viewing/editing the file in Excel (offline) everthing looks like it should, but in Excel Online some of the...

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

Hi Guys! This one should be easy, but I'm just going round in circles trying to fix a simple problem. I have a Form, on which is a Frame within which are four radio buttons with their associated texts. When the Form is Initialised, I'd like the second radio button to be set. Using the following...

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

<tbody> ID number B C D E F 1 109094 2 109094 3 148877 4 148877 5 154470 6 154470 7 154470 8 154470 9 183357 </tbody> I have 566 row and more than 10 columns I have multiple id numbers. I want to...

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

I have a vacation tracker for work, that always me to see when people start and return from vacation or other time off situations. The issue that I am having is two parts. Main one: I have figured out how to calculate the days between days by using b2-a1, but I have to incorporate the times. So...