Search results

I am going crazy trying o figure out why is my countif formula not working. I have attached the spreadsheet for your reference. Thanks Rana

Hi, Can someone please help me crack a formula that satisfies the below criteria? I need the formula to copy the leaving date for a person into multiple lines and stop when a new person appears then do the same for that person and so on. Coloumn 1 = employee unique ID Coloumn 2 & 3 =...

Hello gurus, Can you please help me ? I have gone through various forums but not getting what I need. what I need the macro to do in the ollowing order. 1. Select the specified column ( Colomn heading : name of business partners) 2. Generate an unque list of these business parners 3. Cut...

I am struggling with a formula that i want to work in conditional formatting. I want the cell A1 to highlight if the value of B1 is <3. However the cell should not highlight if there is no value in A1 or if teh value is 0 Thanks Rana

Hi gurus, Struggling to get a median if formula. The one that I am using is =MEDIAN(IF(B:B=B5,C:C)) Want to find the midpoint for the below data. where B = the Range of names B5 = the actual name within the range C = values related to the Bs Personal Job Title (B) Annual Pay (C) Abnormal...

Hi gurus, I have been asked to find what will be the age of a person between 31/09/14 to 31/12/14. The issue I have is that its a date range. I know how to find age between a start date and a perticular date or today (=datedif(startdate, enddate,"Y"). But I am a bit confused as I have been...

Hi All, Can you please help me with this formula where; If DOB1 = 11.11.54 if want the formula to return = 1.12.2013 Thus taking it to the 1st date of the next month in 2013 if DOB2 - 11.3.54 Formula to return = 1.4.2012 Thus taking it to the 1st date of the next month in 2012

Hi all, This is really confusing and I hope I can explain it well. If cell a4=3 then I want cell b1,b2 & b3 to be =3 If cell a10 = 5 i want b4:b9 = 5 so if a cell in coloumn A has the number 50 , the 50 cells above in B row should have the number 50 in them. please help Rana

Hi, I have a coloumn of names and these names are spellet like MarkMR, SteveMR etc. However I also have there names without the MR at the end ( Mark, Steve etc). What formula can I use to look at the last two characters and if 'MR' then remove MR and give me the name else simply return the...

Hi All, The below code only copy pastes values in the sheet that is generated. How do i get it to copy & paste formulas and formats in the sheet that is generated. Sub breakMyList() &#39; This macro takes values in the range myList &#39; and breaks it in to multiple lists &#39; and saves them...

Hi, Can you please share a solution to help me extract contents of a specific coloumn from multiple excel files (saved in a specific folder on my desktop) to a blank new excel file which has the same coloumn headings. Basically I have recieved expense files for the last one year. I dont...

Hi gurus, I am trying to understand how to create speedometer charts. Having read instruction I have managed to put the graph together. My problem :- I want the speedo meter to have a scale of 1-4 and show me 2.63 in the chart. However the donout should also show me individual weights as...

Hi Gurus, I am working on an excel form, I have a need to add a calendar picklist in the form. I have created a userform and added a calendar. I then went back to my spreadsheet created a button and assigned a macro to it. The macro shows the userform with the calendar. My issue is when an...

Hello experts, Please pull me out of this - I am struggling to make anything out of this formula. Need some urgent help to get a formula working. I think I have partly cracked the formula but my boss has added a spanner to the wheel. The formula needs to be in ‘Data Sheet’ - column G in...

Hi gurus, Can you please help me to find a way to give a header to an excel list? cell A1 to be called 'Click Here' and should include a list that I can put using data validation. Please please help as input message in data validation is not a great solution. Thanks Rana

Hi All, How do I give a title to my dropdown list. I want users to see 'Select Here' in the cell. I know how to create a drop down from data validation. please help Rana

I have inserted a radio button that hides rows (3:10). In the same spreadsheet I have inserted codes that need to unhide row (4:4) if I select "yes" from range("A1). The radio button works perfect , however the second code to unhide row (4:4) based on list selection is not working. I think its...

Hi All, I am struggling to put this form together. This is quite a complex form and any advice will be great. https://docs.google.com/open?id=0B_upMYdtf67RSlNvS0pDSWVoN3M I think I have understood the logic of hiding rows based on list selection.However, I cant get it to work :(. Tab 1...