excel question

Dear Experts, I intend to re-arrange the data generated by system. I am using Office 2010 Current Format: Mat No Cost1 Cost2 Cost3 A 5 3 2 B 6 9 3 C 7 6 2 To be Format: Mat No A 5...

DATE BALL # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 10/29/2013 8 8 10/29/2013 3 3 10/29/2013 12 12 10/29/2013 7 7 I made a small sample made hand (number color) I...

Is there any way (like countifs function) to count number of blanks in a column provided a number is present in the previous column, Ex. In the ninth row, the data for 2011 is blank but the previous column some data is present, is there any way I can count such instances using a fuction...

Hi All, Had to know if the frequency array function can be applied for a text which we can by using the following formula "=SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1))" which gives the unique occurrences of text in column A...

M2222 12/07/12 M2230 12/07/12 M1087 12/06/12 M2525 12/05/12 M2525 12/05/12 M8899 12/05/12 Above is an example of what I am working with. I am trying to get a count of how many times the values on the left appear. But in some cases those values occur more than once in a single day. If they occur...

I have an Excel xlsm file that uses several toggle buttons to show/hide columns. These toggle buttons are perfectly aligned on every user screen I have looked at with one exception. On the one user's PC, the toggle buttons are misaligned and are even different sizes. They still function and...

Hi, I want a formula smiler below. =IF(MATCH(B2,D2:D20,0),"MATCH","NOT MATCHED" But when i use it, it gives false value with '#n/a' . pls help in this.

Data <TBODY> 10/01/12</SPAN> 2000</SPAN> 3000</SPAN> 4000</SPAN> 5000</SPAN> 6000</SPAN> 1A</SPAN> 1.00 </SPAN> 2A</SPAN> 2.00 </SPAN> 3A</SPAN> 3.00 </SPAN> 4A</SPAN> 4.00 </SPAN> 5A</SPAN> 5.00...

Hi All, I want help to get a formula in excel. I have a list of mobile no.s and next column of this it's Gift. I want formula that when a mobile repeat or select more than 1 gift then formula merge it separate via "," in next column Data is like below. <table border="0" cellpadding="0"...

I have an active sheet where any of the columns maybe hidden, but I don't know what columns are hidden. How to search the columns which are hidden in the active sheet using VBA. Also I want to unhide the columns whichever hidden, at the same time i want to store the no of columns which are...

Hi Everyone, the below could does direct me to the file, but when I click on the file, it does not open it? any ideas? Option Explicit Sub GetImportFileName() Dim Filt As String Dim FilterIndex As Integer Dim FileName As Variant Dim Title As String ' Set up list of...

Hi, I have two pivot tables: a) SENT email pivot by month and campaign type b) DELIVERED emails by month and campaign type. I need to compute deliverability rate by dividing delivered to sent. How can I do this fast so that data can be refreshed monthly?

Hi, I have a database of 338 members, all the information is entered in an excel sheet (named: Main) column wise, lets suppose the data for the first member is in the row 2 (first row is used for column headers) i.e.: A1 contains Serial (Here 1) B1 contains First Name (Here John) C1 contains...

hi everyone! i'm a newbie here, i had a question regarding inserting a transparent (50%) word art in excel using vb.net. any help? thanks :confused:

I have an Excel file with a sheet that has the following columns: Name, Activity, Start Date, End Date. What I would like to do: I would like to create summary sheet with a calendar-like matrix, with the names as rows, and dates as columns. I would then like to plot the activity in the...