Search results

Hi, I am looking for blocking a seat for different shifts in excel format (similar to movie ticket booking.....Select date,select # of seats,showtime & Price). Does any body have or help on this. Thanks in advance, Suresh Kumar S

Hi, Click on the Values on Pivot table field and select value field setting and change accordingly. You also refer the below link http://www.free-training-tutorial.com/pivot-table.html Thanks, Suresh Kumar S

Thanks Excel Hero Faseeh, Even i tried sumproduct but instead of month i used text formula. Thanks, Suresh Kumar s

Hi, I want to sum all the production hours, present days and no of working days for a particular month. I have briefly explained in attachment. http://www.2shared.com/document/9cTqJACO/1_online.html Thanks, Suresh Kumar S

Welcome Chaitra, You can upload the sample workbooks from the below links. http://www.speedyshare.com/ http://www.2shared.com/ Thanks, Suresh Kumar S

Hi Srijith, Can you please upload the sample file. Thanks, Suresh Kumar S

Hi, I am not sure whether you are looking for the below kind of report. http://www.2shared.com/file/jNjkM_k5/1_online.html Thanks, Suresh Kumar S

Hi Mahaveer, Can you please upload the same file? (Original Data as well as Final Output data in different worksheets) Thanks, Suresh Kumar S

Hi, Insert a Module and paste the below code and try . Sub newsort() Dim k As String k = ActiveSheet.Name Range("A1").Select Range(Selection, Selection.End(xlDown)).RemoveDuplicates Columns:=1, Header:=xlYes ActiveWorkbook.Worksheets(k).Sort.SortFields.Add Key:=Range(Selection...

Hi, Can you please upload the same file. Thanks, Suresh Kumar S

Hi Faisal, Suppose in A1 you have 1440 (In Minutes) then in A2 please apply the following formula =A1/1440 and change the format to “[hh]:mm:ss;@” it will work. Thanks, Suresh Kumar S

Hi, I guess for the range A1:C25 (cells A1,B1,& C1 )should have a header (It should not be blank). Thanks, Suresh Kumar S

Hi Gumbles, Let me check in the mean time our Excel hero also will help you out. Thanks, Suresh Kumar S

Hi Gumbles, You can upload the same workbooks from the below links. http://www.speedyshare.com/ http://www.2shared.com/ Thanks, Suresh Kumar S

Hi Gumbles, Can you please upload the sample workbook. Thanks, Suresh Kumar S

Hi, Can you please try the below code(Insert a module and paste the code). It will select the active row and move the data to approved sheet. So as soon as you entered date and you want to move the particular row from pending to approved sheet is you to run this macro (ALT+F8). Suppose you...

Hi Raj, Can you please download the below file and check. http://www.2shared.com/file/sjvKJfsy/2_online.html Thanks, Suresh Kumar S

Hi, As per my knowledge it can be done through Copy & Paste. Thanks, Suresh Kumar S

Hi, Can you please download the below file and check. (Use Alt+F8 to run the macro) http://www.2shared.com/file/j7fBzY_L/1_online.html Thanks, Suresh Kumar S

Hi Srini, You can upload the same workbooks from the below links. http://www.speedyshare.com/ http://www.2shared.com/ Thanks, Suresh Kumar S

Happy Diwali to all!

Hi, Can you please try the below formula. For Jan =INDEX('Look UP Data'!$D$5:$D$92,MATCH(Result!$B2,'Look UP Data'!$C$5:$C$92,0),MATCH(Result!$B3,'Look UP Data'!$A$5:$A$92,0)) For Feb =INDEX('Look UP Data'!$E$5:$E$92,MATCH(Result!$B2,'Look UP Data'!$C$5:$C$92,0),MATCH(Result!$B3,'Look UP...

Hi seansr, Can you please try below method. (For Filter it will differ from Deb method) 1.select entire column(C) 2.Press Control+1 3.Under number go to custom and paste yyyymmdd (Below type) Thanks, Suresh Kumar S

Hi, Can you please upload the same file. Thanks, Suresh Kumar S

Sir, I am really sorry Excel hero Sir. Your formula is correct as per Diego request. I will make sure it will not happen on-going. Thanks, Suresh Kumar s