in versions of Excel 2007 and up, you can use up to 64 nested IFs. In older versions older than 2007, the threshold is 7 nested IFs. Any ways some...
It is hard to see here, Could you add a screen shot of how it looks like and how you would like it to be
then why not make selection off that cell.
see if this helps http://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007
How are you transposing the columns. To me it looks like you just copied to data from Column 1&2 to column 3&4 and column 5&6 then moved one row...
Since you said the list is big. Best option would be to have a hidden sheet or a visible sheet, where all the titles and codes are listed. The you...
Little confused. In you new workbook there is sheet named Bielen. However there are other sheets too (McGregor) It looks like to me that you...
Try this =IF(AND(ISNUMBER(J35), $M$1>=(J35+21)),"Update Required","N/A")
Using SUM IF, you can get the answer Sheet1 = sheet where your original data is, A= column 1, B=column 2 Sheet2 = sheet where unique data of...
So from what I am getting is that lets say you have 3 rows populated R1, R2, and R3 you can to compare a cell in R2 vs a cell in R1 and if not...
How is your sheet laid out. A sample of how things are and how ideally you would like to see would help
You will not be able to use color to conditional format. What you can do is have A1 be a conditional format based on a OR conditions example...
Actually, this sentence of yours feels very rude "I expect appropriate answer for my question. " People here, are giving time out of their own...
into single excel means into single workbook or into single sheet. Single workbook is quite possible, but into single sheet would depend on...
i am sure you are aware of using of formatting. So I am presuming that change of format is not making any difference. It would be due to that in...
do you plan to keep workbook open all the time, or do you plan to send email once the workbook is open
see if this helps http://ccm.net/forum/affich-258700-interesting-question-for-excel-champions
so potentially you would have two rows for a student with two receipt number(lets say one for transport and one for fee)
I thought you said the sheet is already auto updated.
Depends on what you want to do. One way could be use data validation and other would be to use the vba code
see this http://ccm.net/forum/affich-861811-resize-the-range#p862181
one way would be to use match function and then apply filter to delete rows where there is no match
This is one option Private Function isDuplicate(Target As Range) As Boolean isDuplicate = False If Target.Value "Applied For" Then If...
have you looked at conditional formatting?
some thing like this "T:\Accounting\Aspen Pre-Payroll\_Payroll Emails 2015\303 " & Format(Now(), "mm.dd.yyyy") & " - TI Payroll & Exp...
try this Rngname.currentregion.offset(0,1).resize(rowcount,rngname.currentregion.columns.count-1)
not knowing or understanding all, one suggestion would be to copy from a template sheet on to the main sheet, so instead of fixing a row at a...
you can try sumproduct formula, it will return the count of rows where the match occured. This example is checking how many times the combo of A1...
see this thread http://ccm.net/forum/affich-83550-coping-formulas-to-next-row-using-a-macro
It is same as before in answer here http://ccm.net/forum/affich-859846-add-a-restriction-to-a-column#1 in AND clause add two more for ".com"...
one way would be to combine all columns into single column and then do a column compare
What do you mean count alphabets?
you have to use validation with custom formula is validates your check of starts with 03 and length = 11 =AND(LEFT(A1,2)="03", LEN(A1)=11)
There must be some event that is cleaning it out. Simple test would be Before pasting, execute code Application.EnableEvents = False that...
via vba? shortcut ?
Most easy way would be to pop up a input box where user may enter the folder to save the files. This in simplest form will suffer from GIGO...
if possible, your decision of x vs X is changed, to say X
Seems to me it is very much like this one http://ccm.net/forum/affich-258700-interesting-question-for-excel-champions
Check if Show Formula is turned on. On windows you can toggle between show and hide by using short cut Ctrl + `
Then it would be expensive in term of performance. One alternate way would be to use a user defined formula or still most easy route would be to...
print the sheet as pdf.
your data seems to have lost its formatting.
See this thread http://ccm.net/forum/affich-258700-interesting-question-for-excel-champions
on change works with manual changes. The formula change will not trigger it You should do both task at the same time, meaning populate the yellow...
What is the unique identifier in the sheet ?
Could you read your question to some one and ask that person to tell you back what exactly you are asking for. For any one to answer, one need to...
Not 100% sure exactly what you asked, but would not sum formula work for you
Sounds like you want to copy template and name it as per your call If that is the case then instead of creating a new sheet like this Sheets.Add...
it can be done. again my suggestion to use macro recorder to see how the code would look like hold. What ever way you think you want to go about,...
You can use conditional format So If you click on A1 and then select all columns till column CP and use the formula =AND(A1"",...
DON'T MISS