times

Hi there! So I hope I can explain what i'm trying to do clearly. I have an input table where users input hours for a labor category (column) and a task (row). The user also has the ability to insert more categories (columns) and more tasks (rows). In order for the information to become useful I...

Hi how can i copy a value and paste it lets say 10 times underneath with vba? Thanks, AAT

Note: This was originally posted at https://www.excelforum.com/excel-programming-vba-macros/1274124-help-with-arrays.html I have not been able to get any responses to addressing this. My apologies if this doesn't make sense, I am new to using arrays and have been trying to research this but...

Hello I would like to write a formula that would give me the number of EU countries listed in a single cell. So for instance if I was to check the below cell the result of the formula would be 3. CELL A1: Australia,China,Germany,France,South Africa,Spain There are 28 EU countries so I was...

I have read many posts similar to this but can't get my vba code to work. Please help. Sample data: <tbody> A1 A2 A3 A4 A5 A6A7 </tbody> <colgroup><col><col><col><col><col><col><col></colgroup><tbody> 21609 Gold $10 Person1 1 $10 Raffle1 21609 Gold $10 Person2 9 $90 Raffle1 21609...

I have names in column A, and frequency in column B, some fames are repeated 10 times while most of them are only once. I have count if formula in column B, I need a formula that adds up the frequency only once. So if let’s say name UK appears 7 times, US 11 times and Pakistan 4 times, Sweden 4...

Hi I have list of accounts and I need each account to be pasted 12 times. So I need to transform Column A into Column B. I have 1600 accounts so I was really hoping not to do this manually :))

Hi All I've been on this problem for a while and am unable to come up with an answer for myself. i have two columns both of which contain text columns C & D what I'm attempting to do count the number of times that the criteria i set are in the same row. for example if in column C the...

Good afternoon all. is there a function in VBA to have a "counter" to record how many times a form gets used?

got this frmula here and it does work as long as my numbers are smaller than.10000 =LEFT(H29,3)&"."&MID(H29,4,1) i need to have the decimal point 1 digit from the right. at ALL times HELP

Hello I am trying to extract a date of birth date string held in a cell and put it in a standard US date format in a new cell eg 12/21/1903 The date is being held in a text cell in the following format but is some times surrounded by other data DOB-12-21-1903 Bill Married Mary on 10-07-1924...

I have a userform where users can enter times for a team and i am wanting to add the four times together but not sure how to do it. Each textbox is formatted "0\:00.\00" so that when the user enters the time eg 1500 it shows as 00:15.00 (minutes:seconds.00) I don't even know where to start in...

Hi goodmorning, please can you help, I have a spreadsheet where it has peoplesnames and dates but for example there can be the same name on the same date inputtedmany times so Jo Bloggs on 1st April could be listed 10 times, but Ionly want to count the name once and not 10 times please can you...

<tbody> 2:00 PM 1:25 AM 3hrs.25min. </tbody> Hello, Could you help me with above sample. I need a formula to show total hrs. between 2 times after 8 hrs extra working Many thanks

Good morning everyone, I am working on designing a schedule for equipment in mycompany. I have recently learned about aGannt chart and have been able to build one in my workbook. When a place a start and stop date by a pieceof equipment that time is then blocked off. Here is my problem, often...

Hi All, I think this should be fairly easy but I am just a bit of an issue getting a formula to work. I need to calculate a check digit for a bar code. The # is 3910037276 The instructions to figure check digit are as follows: Work with the leftmost 10 digits. Starting from the left take...

Good evening - love this forum! I am working with the county and trying to figure out how many times multiple departments are communicating at the SAME TIME to our dispatch center. There is this misnomer (which I am trying to prove with data) that the times that different departments queue up...

Hi all. Im trying to work out how many staff i have working between two times and also based on the area they work in. Col A has staff names, Col B has the area they work in, C&D have the start stop time The times the staff are working between are in col C&D and i wish to break them down by...

Hello friends, hope all is well! Can you please help me with the code below: I want the code to close the workbook if: 1. UserName is NOT Johnny Case AND 2. Between times 17:45 and 17:59 OR 3. Between times 07:45 and 07:59 The code is placed below; thank you very much in advance...

I am looking to add a new constraint to my query. I am not sure how to start setting this up. I want to add a constraint to set a maximum number of times a value can be used in my solutions. My loop will run for 1 to a maximum of 150 times. This will be set prior to running the solution...