Search results

Please post the workbook, it will be easy for us to understand the problem.

Select the entire data, Insert Tab & Table. In this table you can apply the Conditional Formatting. As you enter new data the table will get expanded & the Conditional Formatting as well.

Include the headers in the name range, if that is not possible, select the entire data for pivot table (including the headings)& not just the range name. If this does not solve your problem. Please share the workbook.

Please check your workbook, how can t3 come in 3 (In Answer) when in the source data it is t5 has 3

sure, will do it in the excel by EOD today.

It is always better to keep the data in cell & not hardcore in formula,In my example a2 has the Ageing & b2 has the slabs, you can modify the same to fit your cell requirement

If you want to use IF Formula, its nested Ifs & array formula. Assuming that the data is in D2 & you want the ageing (result) in E2, The data Ageing & Slabs data are in A & B. =IF(D2=$A$2,$B$2,IF(D2=$A$3,$B$3,IF(D2=$A$4,$B$4,IF(D2=$A$5,$B$5)))) (Shift+Ctrl+Enter) Array Formula

Assuming that the Data starts from B2 to H2 in B 8 enter this formula =if(b3>0,b2,"") - This will display only the header column which has data greater that 0. In the next column, add this formula, A column is the helper column , so please keep the A column empty...

Insert the required formula in the value field settings in the Options tab

This can be done with conditional formatting.

Go to Data Tab & click on From Web & enter the website name follow the wizard this will help you to get the data from the website.

This query is already replied in this forum, please check the forum posts. This is the heading in this forum Macro required for merging all excel files in a folder

Function CombineRow(myRange As Range) Dim cell As Range For Each cell In myRange If Len(cell) > 0 Then CombineRow = CombineRow & cell.Value End If Next cell End Function Type this formula where you want the result to appear & drag down =CombineRow(A:A)enter

One more, concatenate the SUBID & Date in Column C & apply this formula in Column D =IF(COUNTIF($C$2:C2,C2)>1, “Duplicate!”,”Original”)

Insert Pivot table, drag Subscriber Id & Dates in ROW Lables.Design subtotal donot show subtitle, If there are different dates in the SUB ID, only one date will have the SUB ID & the other will be blank.

Check this out well explained, http://www.ehow.com/how_5766231_create-curve-graph-excel-word.html

Hey kaushik, thanks a lot, Macros will not be of much help to me as the workbook changes every time. I can convert the same to excel addin & then add it to excel. Thanks a ton, you have saved me quite a lot of time.

My sheet has 5000 rows of data & in between there are sum formulas I want to sum only the values in the sum formula Ex: Numbers A1: A10, A11 =sum(A1:A10) Ex: Numbers A15: A30, A32 =sum(A15: A30) I would like to sum only the values in A11 & A32 & not the entire range from A1:A30 IS...

Thanks, Hui,Thanks for the reply I was wondering is it possible by conditional formatting as I need to develop this workbook & pass it on to people, many of them dont even know want a macro is.....

I want the numbers (sum) as well as text to appear in the Pivot table, The column has Month & in some months the numbers need to appear & in some text, the base data from where the pivot is linked is in the same format like numbers for some months & texts for some month, but Pivot cant display...

Thanks to Luke & SirJB. I will try it out.

I have an excel which has data from A1:E800, the data consists of 10 departments. Every time, I create 10 different excel for each department. This is done as one department should not see the data of another department. It is a very time consuming task. My question is can I protect the sheet...

I have 2 books, Book1 & Book2. Both books have the same format. In Book1 & Book 2 C & D columns has values & E columns has a % formula, G & H columns has values & I columns has a % formula. Like this there is lot of columns that has values & there corresponding % formulas. Note: In Book1 the...

Hi, Can someone pls guide me on this issue.

I need to divide 2 numbers based on a condition A1 has June, B3:M3 has months, June, July, AUG.... There are numbers in B4:M4 & B5:M5. I need to divide B5/B4, if the month is June in A1, if it is July in A1, it should c5/c4 & so on