col

Based on the posts I've reviewed I'm not the only one looking for a STDEVIFS function in Excel. I'm trying to get along without it by using IF and AND. There are two criteria that need to be matched and if they match I want the STDEV. I am trying to get Excel to calculate STDEV for a...

Hello, If (Col B) Manager is equal to: Brian OR Mike OR Shawn then, using the grade field (Col A) output the corresponding average value associated in Sheet2 (Col D and E) If (Col B) Manager is equal to: Julie OR Sharon OR Liz then, using the grade field (Col A), output the corresponding...

Hi, i need some help. I try to google but see hard for me :( In myweeksht; At Column D 1. Find WPxx And Replace with 'Poster' 2. Find number (the number can be single or double digital) And replace with 'Route' <tbody> Col D Col D (Result) WP1 find WP @ Col D & replace with 'Poster Poster...

I have a userform ComboBox that pulls drop down list from Col A of another sheet in workbook. This list in Col A is constantly added to manually. i.e. I have new clients to add. How can I avoid adding new clients manually in order to show up when using the userform ComboBox. What code can I...

Hi , I have values across row 4 from col A to Col AA that I have to concatenate and separate by commas. I believe I saw a third party solution with a custom MConcat or something like that. Can someone advise best way to concatenate without typing out A4&","&B4 etc... Thanks

I have two worksheets' data. Worksheet Tags. Worksheet Records. Only Worksheet Tags has data in col P. Worksheet Tags has only SOME of the same data in col A that Worksheet Records has in col A. With matching data in col A, whatever I can do to copy Worksheet Tags' data in col P, inserting...

Hi , I have the below code that I want to tweak , I receive fileswith 820 columns (AEN) and each column has different character lengthrequirement. EG. Column A ColumnB Column C Etc Len = 3 Len = 10 Len= 50 Etc...

How can I to split data in WS Sheet Column 'D' into Columns 'C' thru last column and place it under the right date. For example the Template sheet would have all the team schedules under the date they play, the court they play on and the time. A snippet of my macro thus far is shown at...

Hi to all of you, kindly require to provide me support so that a VBA code to run through column "H" and where cells contains the text like "Electricity" should place the code "105020100". in adjacent cell in col. "F" Thank you all in advance

Hi all, I'm really struggling to find a vba solution here. All I want is a msg box to pop up if my table has duplicate rows. e.g. <tbody> Col 1 Col 2 Col 3 a x ee b s rr d z sg a x ee k l aa a r aa </tbody> Since row 2 & 5 are dups, I would want the msg box. Many thanks James

I need some help get from Table 1 to Table 2 then Results please Book1ABCDEFGHIJKLM1Table 1Table 2456Results21231617181617183456Y1920211920214789Y22232422232451011122526272526276131415Y282930282930Sheet1 Book1ABCDEFGHIJKLM1Table 1Table...

Hi Experts, Please assist me in adding one more knowledge here. Whenever we filter to headings, i observed that suppose if my cell selection on col AO or any other cell, if i use Ctrl+Shft+L for filter, sheet view jumps to left i.e. col A side.. How do i keep freeze this view on my selected...

Hey all, I have column A containing positive and negative numbers and I am looking for a formula in column B for sequential numbering as follows col A col B 20 PS001 32 PS002 20 PS003 -20 NE001 10 PS004 20 PS005 -10 NE002 10...

Hi, Column A has a list of fruit. A1: orange A2: orange A3: orange A4: kiwi A5: kiwi A6: blueberry Requesting VBA to loop thru column A. Then Copy value to cell B1 until value changes. Then cell C1 etc. in example, result is: col b has b1 thru b3 with orange, col c has c1 thru c2 with...

Hi all, i would like to use VBA code so that to delete entire row if met two criteria. Col."H" is 0 (zero) and col. "N" is blank. Thank you all in advance

Need some help please I have a tab with quite a few columns and need totals Col A = Staff Names Col B = Course Name Col C = whether they have Pass or Fail Col D = uk or non uk i wish to creat a new tab and count how many staff have pass or fail and if they sit in Uk or non uk New tab with...

Hi All I would like to columns A3:I40 with a Deactivate event. Column A is a number column and is what I need to sort by. I have 3 columns with formulas that need to stay intact. Col D:=IFERROR(INDEX('Fixture Specs'!$A$2:$A$4000,MATCH(B3,'Fixture Specs'!$B$2:$B$4000,0)),"") Col...

Hi, I been looking all over the place for a solution. I created two macros one to highlight the duplicates and other one to filter on the highlighted ones. I have the result set with all the duplicates and I need to take the max of Col L if that column doesn't contain zero, if it does look at...

Hi all. A col has Dates in them this sheet is called "Log" Col A Col B Col C Wed, 19 Jun 19 5:30 6:40 Fri, 21 Jun 19 1:49 1:23 Fri, 21 Jun 19 1:11 Fri, 21 Jun 19 1:33 3:12 I have another sheet that has dates for JUNE sheet name...

Hi guys, Can someone please help with a formula? I have a list of names in column A, and some dates in column B. I need to work out how many names appear more than once between certain dates. E.g. I want to use the date range from 01 to 10 June. I have those dates in separate cells (e.g...