steve

I have a sheet that i want to import data to (sheet1 B2) this data is seperated by a comma i want to seperate and create it listed in a single column on (sheet 2 B2, B3, B4 etc) can someone please help with a formula thanks in advance

Hi All , and thankyou in advance for looking at this problem. I am adding 2 cells together for an email address , first name , last name with a . inbetween , then the email address ;EG STEVE SMITH , it should read as steve.smith@blah.com. However only on a few occasions there appears a space in...

Hi, I need to build a report that can look down a list of line managers and determine the employees that sit under them whether directly or indirectly. For example, the CEO may have 5 direct reports and each of those reports have a further 20 reports. The formula would need to return the...

Good morning ... I'm not sure if this can be done, or even how exactly to describe it, but here goes ... I need to create a "ballot" file, which I will then refer to after generating a random number using a formula. I have a source spreadsheet with names and the # of ballots each name gets...

Hi Guys, I am working on a piece of work where i ahve a list of names and dates next to them. What i would liek to do is excel to scan all the dates and any date less than today to return the name to the left of the date however i only want it to build a list of names that have expired and not...

<tbody> A B C D 1 Name Number Name Number 2 Alex 15 Sarah 45 3 Eric 20 Steve 33 4 Steve 33 5 Seth 33 6 Sarah 45 7 Erica 50 </tbody> I need to be able to Search Column A, find a Match for column C. Once that Matches, I need to Fill Column D with the same number to the...

Hi everyone, new to the forum and would like some guidance on some formula i am stuck on: we have a large dataset which has some info re staff absence days , and looks like the below. what i am looking to do is increment by 1 each time the staff member in question is registered as being absent...

I am using a script from Run De Bruin to email from excel. However it pulls the signature from the default email account. How can i create multiple signatures and swap them based on a cells content? IE. if b1 - mike then the email would be mikes signature, if b1 = steve then it would use...

I have a table of production and I would like to be able to show one person how they compare to other doing they same work without showing the other names. For example: steve compare to person 1, 2 ,3 and mary person 1,2,3 without making a separate table for each person.

i have been working on an efficient way to get this excel data to transpose in the way that appears underneath it, at the bottom of the post the way i do involves several steps and its painfully slow, and the data set can be large, and as i need to do it 3 times a week, I'm hoping for a faster...

I am very new to vba and some help creating a code. I need to cut each unique Name record and paste it into it's own new sheet. I tried to find an existing code but had no luck. Can someone help me with this? <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Name...

This is probably very straightforward but its doing my head in, can someone help I have a worksheet which has two columns one with Names the other with value, all i need is a formula in column 3 that will return for each individual "lowest" for the lowest value attributed to that person and...

Hello, could someone please help where and how I would place the IF formula to remove the #DIV-0! error im using =(O18-H18)/ABS(H18) but there is on value in cell H18 so it returning an error Many Thanks Steve

Is there a formula/macro that will allow me to remove all carriage returns within a cell? I can't seem to remove them and I've tried a number of things to remove them. Can someone please help if they have a moment? Steve

Hi, This is my formula: =IF(O4="","",SMALL(IF($C:$C=O4,ROW($C:$C)),COUNTIF(O$4:O4,O4))) I want to add if($b:$b=n2,ROW($b:$b). I tried putting it in the middle but it says theres an error in the formula, what am i doing wrong? Rgs Steve

Hi, This is one formula i have: =IFERROR(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!C:C,ROW()),'Main Squad'!$A$17:$AM$17,0),0),"") & this is another: =IF(Table7[[#This Row],[POSITION]]="Goalkeeper",(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!$C$1:$O$1,),'Main...

Morning All, The status bar looks like it is in two halves ? or am i wrong (i can see a dividing line) I can put a message in the first part by Application.StatusBar = ("Updating Sheet Data Please Wait") i am wanting to put a status of something in the second half is this possible how? Can...

Hi, This is one formula i have: =IFERROR(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!C:C,ROW()),'Main Squad'!$A$17:$AM$17,0),0),"") & this is another: =IF(Table7[[#This Row],[POSITION]]="Goalkeeper",(VLOOKUP($B3,'Main Squad'!$A:$AM,MATCH(INDEX(Sheet1!$C$1:$O$1,),'Main...

Hi All, I was wondering if anyone could help me, i have a list of people, and payments. for example : <colgroup><col><col></colgroup><tbody> Eddie 10 Steve 12 Steve 65 Steve 12 Steve 12 Steve 35 Steve 56 James 66 James 73 James 21 James 33 James 21 James 21 James...

Hi all, I am hoping that the following is possible to be done with vba code. I have searched but am struggling to find code to cover all of this. I have broken this down into 3 separate stages below. I have a set of data in an excel spreadsheet that runs from column A to Column K and 6000...