colum

What is the best way to set column "J" to upper case?

I have a date in a cell on a table and I want to use countifs. I want to say count the number if records where the date (in date and time format DD:MM:YY HH:MM) where the date is over 30 days ago from today and less than 120 days ago where the status of the customer (colum M) is Sale completed)...

Hello! I have a problem with an excel sheet for work. Hope you can help! I have to order employees by their entry time to work, and also by their role inside the company. So, for example: <tbody> Colum A Colum B Colum C 1 Matt (regular employee) 07:00 15:00 2 Philip (supervisor) 07:00...

Hey all, trying to understand vba and it’s a bit hard for me :/ I have a question, I want to make a macro which move on each colum and take all the data in it, check how much there is specific numbers (countif I guess) (1-2,3,4-5,6,99) and then make it into a graph on new sheet then move to...

I would like to insure that when ever a workbook is opened it would automatically: Sort all the entire workbook small to large in Colum a, retaining the headers? Thanks -Eds

Hi guys, im new here and have a question. I have a table with 14 colums. In colum D are costumer numbers. I want to check with a VBA if a costumer number inside more than one time. In colum C are order quantities. If the costume numer dublicate i want to sum all of the order quantities from...

I have the following date in A2 down Columns A: V:\Quotes\!Pricing Department Folders\Tools\BOE TEMPLATES\Under Development\Q015742 BOE Import X1.xlsm Colum B: 5/22/2018 10:11:13 AM Column C: ENGINEERING_SMITH Columns A: V:\Quotes\!Pricing Department Folders\Tools\BOE TEMPLATES\Under...

Hello guys, I have this colum with information: 908 34 89 908 How can I have excel show me how many duplicates of the same number (such as 908 in my example) are in this colum and maybe show me which ones are? Thanks!!

Hi, I'm am trying to perform a sum if on the below data. I want to sum only the numbers that begin with the year 2018 (or what ever selection I chose) so I tried the following but it returns zero? =SUMIF(A1:A8,"2018*",B1:B8) Also tried with 2018 typed in cell G1 =SUMIF(A1:A8,G1&"*",B1:B8)...

Good day, I have a spread sheet that consists of two sheets, sheet one has my sales agent in colum A and dealer codes from B-L, sheet two has die dealer code in colum A, dealer name in colum B and in Colum C I need to find the correct sales agent from sheet one for the specific dealer Please help

i have 2 sheets, in sheet 1 i have a site appering more than 1 time under site id colum with different enrty in collo response. i want the entry on a single coulmn for the unique entry in sheet 2 e.g sheet 1 SHEET 2 COLUM A COULM B...

So I think I need an if statement but I cannot seem to make it work but here is my problem (hopefully I can explain it well enough) Colum A is a number (meters squared of work completed) Colum B is size of rock used (naming convention used through drop down box being used a total of 5...

Hello, Please i need your help anyone. I have a multiple sheet containing transactions from different client and a colum showing revenue for each of this client. I will like to get the total per client on each sheet separately.

Hello, I have the code below which I would like to add to: Sub New_Risk() Dim varUserInput As Variant varUserInput = InputBox("Enter Row Number where you want to add a row:", _ "What Row?") If varUserInput = "" Then Exit Sub RowNum = varUserInput ActiveSheet.Unprotect "test" With...

Here is what I need to do. in the example below I need Colum L (Velocity Code) to have a formula that if Colum K (Hit Count) has a number >250 it puts an "A" in the Velocity Code Colum. But if it is <250 but >100 it puts a "B", if it is <100 but > 50 it puts a "C", <50 but > 10 it puts a D and...

Hello there, im not sure how to ask my problem, but i got the picture of it. The point is i want to know which colum is my checkmark in some arrays. This is the pict: How do i write the formula? Wish for the helps. Thanks :confused::confused:

Hi Excel experts, I have been trying to do this for way to long and it’s got to be a simple syntax so hope you can guide me in the right directions… What I would like to do is, Find text in a Row get the Column number and then change the properties of that column, snippet below. This code...

Basically I have been working under the assumption that people would not need to insert or remove columns in random places. So my code has statements such as: Cells(sumrow, 5).FormulaR1C1 = "=Takedown!R" & startrow & "C" & 45 - 4 If Cells(9, 7).Value = takedown.Cells(startrow, 4).Value Then...