Re: TO many arguments
Actually, the 2nd one you posted works -- it's not calculating right but I can figure out where that is off. Thanks Rooster!
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
Re: TO many arguments
Actually, the 2nd one you posted works -- it's not calculating right but I can figure out where that is off. Thanks Rooster!
Re: TO many arguments
Same error, I ended up just splitting it into a helper cell and adding them together not ideal but it works
Re: TO many arguments
You are looking at it wrong
First Formula:
IF(D4="",""
Says if D4 is blank, then blank else move to the next nested formula - The way you have it saying is there is no argument, if D4 = true else false
Does anyone see a problem with this formula? I simply don't see why i'm getting a to many arguments rule hard stop. It says the to many arguments is in the last value if false spot at the end of the formula. I'm sure I am missing something very easy and retarded, but I simply can't figure it out.
=IF(D4="","",IF(AND(Data!BO4="TRUE",Data!H4=7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4+'Base Price Charges - Credits'!R4-'Base Price Charges - Credits'!$U$2),IF(AND(Data!BO4="TRUE",Data!H4<7),VLOOKUP(Data!$D4,'Program Codes'!$A:$AH,MATCH(Data!$E4,'Program Codes'!$A$1:$AH$1,0),FALSE)-'Base Price Charges - Credits'!Q4-'Base Price Charges - Credits'!$U$3,0))
It's bold and underlined where the to many arguments is coming into play
Re: Sort by Column C -- Pull out certain names, paste unique name tasks to new sheet
I am trying to do exactly what you gave to me as an example.
The only difference is, I want it to be the same people it pulls, every time. I can edit the code as needed to add/remove people when the time comes. I previously said random 3 previously but that was a misunderstanding. Like I meant just pull 3 people off the list and have it pull those 3 people each time.
Re: Sort by Column C -- Pull out certain names, paste unique name tasks to new sheet
I will edit the code if I can see how to do it. It's actually way more than 3, but it could change with new employees coming in and some leaving.
If you can set it to pull out, like NICKERSON, DANIELLE and NOLAN, LYNDA I am sure I can figure out how to alter the code to pull the others I need.
Thanks for your help!
Re: Sort by Column C -- Pull out certain names, paste unique name tasks to new sheet
Quote from jindon;631586Try the attached
Code Display MoreOption Explicit Sub test() Dim a, i, x As Object, sn As String Application.ScreenUpdating = False With Sheets("sheet1").Range("a1").CurrentRegion .Parent.AutoFilterMode = False a = .Value With CreateObject("System.Collections.SortedList") Randomize For i = 2 To UBound(a, 1) If a(i, 3) <> "" Then .Item(Rnd) = a(i, 3) Next Set x = .Clone End With For i = 0 To 2 sn = x.GetByIndex(i) If Not IsSheetExists(sn) Then Sheets.Add(after:=.Parent).Name = sn End If Sheets(sn).Cells.Clear .AutoFilter 3, x.GetByIndex(i) .Copy Sheets(sn).Cells(1) Sheets(sn).Cells(1).CurrentRegion.Columns.AutoFit .AutoFilter Next End With Application.ScreenUpdating = True End Sub Function IsSheetExists(sn As String) As Boolean On Error Resume Next IsSheetExists = Len(Sheets(sn).Name) End Function
This is very close, nearly exactly what I want -- except I want it to be specific people. This example pulls 3 at random, I want the same three - every time. Make sense? Thanks for your help, you have been extremly helpful thus far
Re: Sort by Column C -- Pull out certain names, paste unique name tasks to new sheet
Disregard, I found it.
The only thing I am looking to do now is to sort by a specific set of values. Say there is 15 names on the task report, I want to pull out the tasks for the same people everyday -- that's really what I am trying to do.
Re: Sort by Column C -- Pull out certain names, paste unique name tasks to new sheet
Quote from nilem;631440maybe so (I tried to remake my example for your file), see attached
This is close to what I need! Wasn't quite what I was thinking, But I like where it's going.
How can I edit this code? Under the ert macro, I see no code other than:
I know there is more to it than this, where should I be looking?
Basically what I am looking to do is sort this work sheet by who the file is tasked to. Then I want to pull out certain people with tasks and paste those tasks to a new sheet, a seperate sheet for each person.
The tricky part is that I don't need all of the individuals on the report, just certain ones.
Worse case, I could write a new Crystal Report to only pull the tasks for the individuals I need, but that can be a large pain for seperate reasons. Here is a sample of the data I need to sort. The tasked by is in Column C.
So for a quick example, say there is 10 unique values in column C -- I only want to pull say 3 of those people with tasks to them, have them sort, and each persons task post to a new sheet in excel.
Thanks for any guidance (I have good programming knowledge, just not with VBA or Excel)
I am looking for help on this - or really to know if this is even possible.
I am looking to generate a process to take a list from excel and create an email - send it to the people labed in let's say cell B2, C2, D2, E2 - and attach a file based on a search with the value in cell A2.
The files that need to be attached, are all in the same folder and have a specific name. Basically I would want it to search the folder, and attach the file if the file name is the same as the name in the cell A2
I've attached a sample spread sheet, with sample data. Each Row from 2 on would be a seperate email. The value in the A column would be the file name - and B through E would be the people the email is sent to.
What do you guys think?
[TABLE="width: 648"]
[tr][td]File Name
[/td][td]CC
[/td][td]CC
[/td][td]CC
[/td][/tr][tr]
[TD="align: right"]257215102[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]653232656[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]212154212[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]215132152[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]213512135[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]213253213[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]213513212[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]213513212[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]2131532132[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr][tr]
[TD="align: right"]6513213522[/TD]
&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][td]&amp;amp;amp;quot;[email protected]&amp;amp;amp;quot;[/email]
[/td][/tr]
[/TABLE]
Re: Adding Cells, if Sum is Greater than - How much greater?
I think it would be something like this:
=(IF(AND(SUM((K2:DD2)-K2,L2,M2,N2,O2)),>1.75),1.75-(SUM(K2:DD2)-K2,L2,M2,N2,O2)),0)
Good Morning,
I am looking to make a formula that will add up a range of cells, minus a few other cells, then compare it to 1.75 -- if the sum of those cells is greater than 1.75 -- I want it to reply with the how much greater the value is than the 1.75
So far example.
Cells K2:DD2 - Cells K2, L2, M2, N2, O2 = 2.75
I want it to see that 2.75 > 1.75 and the result displayed in the cell would be 1 (it's 1 point greater than its comparison) If it is NOT greater than 1.75, I want it to display 0
=SUM((K2:DD2)-K2,L2,M2,N2,O2)) > 1.75 = Amount - X - 1.75 -- Want X to display.
Any ideas how I can do this?
Re: If / Or together
=IF(OR(Data!$D2,CF1501,CF2001,CF3001),AND(Data!$L2<95,Data!$R2>=620,Data!$R2<=639),0.75,0)
This is where I am at now, I think it's correct but it says it's to many arguments
Hi All,
Here is my problem and the code I thought would be correct:
=OR(Data!$D2,CF1501,CF2001,CF3001)AND(Data!$L2<95),0.75,0)
Basically, If Data in D2 is CF1501, CF2001, or CF3001 AND Data in L2 is less than 95 -- I want it to return .75 -- if either is false.. than 0
Where am I going wrong?
Re: If Contains, And Statements
Well it has to search for the HB -- because I want it to return true on CF300HB -- but return false on CF300 -- for example