Search results

Thanks getting back to me Luke!

Hi, just wondering if there is any relationship between the sign-ups for the forum and the newsletter. I obviously have a forum account, and now want to sign up for the newsletter, and was wondering if I should use the same email or if it is OK to use a different one. (I have a few email...

Ah yeah, pivot table works... I never remember about pivot tables, thanks!

Hi, I have a data set that is just random numbers in column A between 0-99, but there are also some blanks because there were no readings from the raw data when it was taken. But these are not true blanks, they are like a "" so read as text? In column B I have criteria "A", "B", or "C" To find...

Thanks @azumi :)

Now if i want to make it a UNIQUE sorted list with a criteria... I would need to add a parameter like IF(countif([area above], list)=0,...) but i can't get this to work now...

ah thanks! small amendment for the criteria = =IFERROR(INDEX($A$3:$A$10,MATCH(SMALL(IF($B$3:$B$10=1,COUNTIF($A$3:$A$10,"<"&$A$3:$A$10)),ROW(1:1)),IF($B$3:$B$10=1,COUNTIF($A$3:$A$10,"<"&$A$3:$A$10)),0)),"x")

I use to do that and use red or green shapes to colour in the background of the graph to indicate where was the "good" or "bad" areas of the chart to be in... fidely to get right, but the result is easy to understand

Hi, I have a list of text and a column with criteria (1 = yes, 0 = no). I need to be able to sort this list aphabetically and exclude the "0" on criteria. Looking at some Chandoo posts and others, I know the formula will be an array style with the following format...

I figured out how to get an input for the date working, and used your section of code above to search for the date. Updated file with both macros in it. I think the give the same results! my code as below. it is long and messy! Sub CreateMailMerge() ' ' CreateMailMerge Macro ' takes info from...

@GCExcel WOW!! thanks GC Excel, that is amazing! I would never have known to work through a class based array like that. I have been plugging away trying to make it work on a straight copy/paste each cell process... which is mostly working, but was struggling with section on multiple emails...

oh... maybe it as easy as??? ' define worksheets Dim data As Worksheet Dim mailmerge As Worksheet Set data = Sheet2 Set mailmerge = Sheet4

@dan_l While the array option looks handy for a direct tranpose, I am mixing and matching data around to get it into the layout I need. I think this would make it a bit too complicated. @Marc L Thanks, I do like only having one line of code for this step! I take it by using the .value...

Hi, this is a portion of code that is contained within a loop, where "data" and "mailmerge" have beend defined as worksheet names. It feels very clumsy to go select sheet, select cell, copy then select sheet, select cell, paste... is there a better way of doing this? ' copy paste customer...

a combination sumproduct and mod!! for odds: =SUMPRODUCT(--(MOD($B2:$F2,2)=1)) for evens: =SUMPRODUCT(--(MOD($B2:$F2,2)=0)) PS - bah Narayan, you always beat me!

your welcome ;)

Hi Kchiba, I think the formula should be modified to read =IF(COUNTIF(B2:M2,">600"),FALSE,TRUE) to give the result as requested I find it makes more sense to me to be consistent with the requirement and write the formula this way: =IF(COUNTIF(B2:M2,"<=600")=12,TRUE,FALSE) Or you could do an...

I have re-posted this in the macro forum <here> Please put any replies there, this thread can be closed

Hi all, I'm reposting this from <here> to the Macro forum as I believe it needs a macro solution. Bascially, what I need to do is transpose and re-align a messy set of data from the "Data" tab of the attached sheet into the tab "Mailmerge". The format on the Mailmerge tab is how I need it to...

Hi James, Please see attached file to confirm if it answers your query. The formula used in cell C2 to identify if a "Gold" condition is required is below, and copied into every column with heading "Gold" =IF(B2=MAX(B$2:B$7),"Gold"&COUNTIF($A2:A2,"gold*")+1,"")

This post may be helpful to you? http://chandoo.org/wp/2012/10/04/formula-forensics-no-030/

Sounds like a sumproduct formula could be an option? something of the form: = sumproduct((data1column="criteria1")*(data2column="criteria2")*(data3column="criteria3")*(qtycoloumn)) or a simplified version = sumproduct((a:a="a")*(b:b="b")*(c:c="c")*(d:d)) If you set up a list of the criteria...

Nice, another fun cricket file!

Hi all, A tricky one that I can't work out that I would love some help with. In essence it involves transposing a set of data into a form that can be used for a mail merge. I have attached a file to work with and try and explain the need. The "Data" tab contains the original data. It is not in...

Little excel file to simulate a T20 game based on randbetween() Enjoy it!