guidance

hi all, Need your guidance if possible on how to amend the below array formula to do a lookup all tabs listed below? =IFERROR(INDEX('4.RANGING CONVENIENCE'!$B:$B,SMALL(IF(B$1='4.RANGING CONVENIENCE'!$A:$A,ROW('4.RANGING CONVENIENCE'!$A:$A)- MIN(ROW('4.RANGING CONVENIENCE'!$A:$A))+1,"")...

I am attempting to write a nested if formula that currently looks like this =IF(I15:L15="NA","NA",IF(I15:L15="No","N",IF(I15:L15="Y","Y",""))) and am not getting the expected results. Currently cells I-L all equal NA. I'm sure I did something wrong and am looking for guidance to fix this or even...

I have a table with world wide location data where each row includes the location's continent, approx 4,500 rows. I have a macro that runs a query on all the data but would like to include a checklist which would restrict the query to selected continents. I've set up a Form Control checklist but...

I had some help with this recently and its been working great until now! I have just tried it again and have hit a snag - using the code below it is successfully deleting all but 'Anglia' which is being replaced with #N/A but the rows remain. Dim Addr As String Application.ScreenUpdating =...

Hi all, I am a new user to Excel and would like to create a roster for work. I am a teacher and I need to allocate staff to Areas around the school for supervision. I have attached the roster outline with some random names and criteria for the roster. I feel that with some guidance in the right...

Hi All I have tried the following code which does not complile and would be glad of some guidance. ActiveCell = Application.WorksheetFunction = Sum(Range("F" & N + 2, "F" & R)) Thanks Rob

Hi I am looking to do an If function that if e.g. A3 = 0 then B3 = 0.0% Z, otherwise 20.0% S So I thought this would be =IF(A3=0,''0.0% Z'',''20.0% S'') Excel doesn't like this! So would appreciate some guidance where I am going wrong. Thanks.

Hi Guys, I'm currently at college, and on my new course, we have started a module that goes over spreadsheets. As I am very new to using spreadsheets, would it be possible if anyone could give me any guidance on completing this task? I will attach a dropbox link for you to view the question...

I'm after some guidance. I have a file that is currently 30,000 rows with lots of formulas, I'm wondering if a UDF or 3 would assist in the speed and data return example =IF(O29637="","",IFERROR(IFERROR(VLOOKUP(O29637&"",NAMES,2,0),VLOOKUP(--O29637,NAMES,2,0)),"")) or...

Need guidance with formula for inventory scenario Hi Team, Need your expertise with one formula... Scenario - I have 1700 no of boxes. each box has 12 packs/pieces inside. If I sold 75.4 (sometimes the boxes and decimal number will different as per the order) balance should be 1624.8 its by...

First of all "Thank you" for reading this message and considering some help with my questions. Attached is a department schedule pdf. and I need a spreadsheet done so I could view it with the bar graphs and also a weekly spreadsheet to my weekly dates. My knowledge is best at "novice of excel"...

I have this Excel file I created back in 2003 with various macros but I can't find the method of opening the actual macro file XLSM ! I am using 2010 version and would appreciate guidance on how to open it. I do have the developer tab in my ribbon. thanks Ron

Hi all, I've not used tables yet but I think they will help me to add some new features and functionality to my current workbook. I would like to represent and pull out values in what will be a 'three dimensional' table. Column headers will be 'Assessment Objectives', rows will be 'Strands'...

Hi all, Does anybody know of an excel formula to convert percentiles to T-scores/z-scores? Any guidance or tips would be greatly appreciated... thanks!

Hi In Excel, you can use the function ThisWorkbook.SaveAs In an Access database, how would I do this? Appreciate any guidance Many thanks

Hi & Happy New Year 2018 Am i being too simplistic? Trying to check if a COM Add-In "BERTRibbon.Connect" is installed and if not ignore a line of code that then turns it off If Application.Addins("BERTRibbon.Connect").Installed = False Then GoTo jmp This doesn't work, and I guess because...

Howdo I modify the formula below to includea 2nd criteria. I want to check if the value in range Crng is equal to f OR c. I have tried several ideas but none work. Any guidance would be welcome. I am trying to count the number of unique items in range Nrng where the adjacent cell in range...

Hi, I need to shift a column range to the right by 5 when I drag down one row. I.e. lets say I have values in A1:Z1 and I want to sum 5 cells at a time so A2 = sum(A1:E1) A3 = sum(F1:J1) and so on By following the guidance in this link I have managed to do this with ONE cell, but I need...

Hi Team, I need your guidance to convert "0 degree 46 minutes 40 seconds" to "Hours:minutes:seconds" format in Excel.Could you please direct me to get correct solution . Note : 1 Degree = 4 Minutes Regards, Bharathkumar

I have a formatting macro that works on the active sheet. (I just go to the worksheet that I want to format and then run the macro) I would like to be able to select multiple sheets in a workbook and then have the macro work on all selected sheets. I don't know how many sheets may be in the...