advise

Hi Forum -- I'm looking for advise to assign values in column B to the unique values in column A. The results will look like column C. Thanks! ------ A | B ------ A | B | C | 1 C | 2 C | 3 --- C --- A1 A2 A3 B1 B2 B3 C1 C2 C3

Hi, I would like to be able to see the £ sign for when the code below is run. Please advise thanks. Private Sub CommandButton1_Click()MsgBox "Entered value is " & Worksheets("DATABASE").Range("A1").Value End Sub

I get workbooks with two sheets, that I format for printing, like, changing from portrait to landscape, zero margins on both sides, 05 top and .25 bottom, on one page etc. I do it with so many workbooks is there a faster way of doing this? Will macro work? Or is there a copy and paste of...

I just started learning Reporting Services of Ms SQL Server and found it is no match with Power BI from a beginner view. Anyone is still using Reporting Server and please advise if I should continue with MS Reporting Service or simply jump onto Power BI instead ? What is the advantage of...

Good Day What would be the script to populate multiple cells containing different text with the text for a given cell. Please advise.

I'm looking for a formula to convert a text value into a time value in a excel data base text value "0930a" --> need to convert to "9:30 am" as a time value. Thank you for any advise.

Excel is not adding the North region into chart. Chart data range is =Test1!$B$5:$D$9,Test1!$F$5:$H$9 Could someone advise please?

Hi, My staff enter a numeric value into a cell. This value needs to start with 0 but some staff keep forgetting and just enter say 12345 as opposed to 012345 Can you advise how this is formatted so next time a value without the 0 is entered then leaving the cell etc will add it. Thanks

Good afternoon - can someone please advise as to how I can do this? Regards Pete

I'm using the formula: =IF(ISNA(VLOOKUP(B12,'Allocation %'!B13:C63,2,0),"NotFound")) but I'm getting a 'too many arguments' error. I can't figure it out...... Any advise much appreciated.

If I change the following in the formula "F:F, to F11:F10000" =SUMIFS(INDIRECT("'"&$F$4&"'!F11:F10000"),INDIRECT("'"&$F$4&"'!C:C"),$E11,INDIRECT("'"&$F$4&"'!A:A"),$E$4) I get the VALUE error Can anyone advise Thanks lepend

Hello - I was wondering if I could get extra eyes/minds to the following post I created at OzGrid.com. Would greatly appreciated. I would explain but it would make more sense to visit the following link. Please advise if this post is in violation of any Mr.Excel rules. Thank you...

I have recently deleted a file and every time I open Excel I get the error message "Sorry, we couldn't fine C:\Users etc etc Can anyone advise how to correct this? I am using Excel 2016, many thanks

Morning all, In a workbook i have 6 worksheets. The worksheet i am working on ive noticed the insert button is greyed out. Look at the other worksheets 3 are ok but 3 are greyed out. Can you advise please

Hi, I am using this code below but i would like to also add the current date when its run. +TODAY() isnt correct so please can you advise how its done. Private Sub Imageline_Click()Rows("6:6").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Range("A6").Select...

I am getting an error of ' you have entered too many arguments' for this function. Can you please advise what i am doing wrong? Thanks in advance: =IFERROR(m2=130,VLOOKUP(J2,Mapping!A:C,3,FALSE), IFERROR(M2=1&D2="FZ",VLOOKUP(D2,Mapping!B:C,2,FALSE), iferror(vlookup(d2,Mapping!B:C,2,false),))

hello, I have tried to do this my self but this is abit bigger than my skill set, im trying to make my grading spreedsheet easier for me to read, I have want to have it so that when ever I pass the pass work I want it to come up with pass and then when I pass merit, I want it to say merit, so...

Hi all, How can I add a Calendar into few cells in my spreadsheet. I have created a cell to input the dates there. I have seen some user who simply click on the cell and the Calendar pop up and they can select the date whatever they need to instead of typing it. Will appreciate the help. I...

Hello I'm trying to put together a rota macro for some employees. In a nutshell the employees all rotate round on a 13 week cycles which dictates when they're booked days, nights and off. Can someone advise how I can do this? I imagine it'll involve a spreadhseet which shows the 13 week...

Dear all, Can you please help me with the following: I would like to highlight the CELL in COLUMN C if the corresponding CELL in COLUMN D is empty. Kindly advise. Kind regards, Opgelost