uploaded

I sometimes take screenshots on my 4K monitor and upload them to Imgur so I can embed them. Any ideas why they come out so large? It's not a problem on mrexcel.com. Even when I view them on Imgur.com, they look big there also. Example: They seem to be getting scaled up by a factor of 2.5.

I'm a flight simulator pilot, (which will help to explain the nature of the spreadsheets when you see them.) Anyway, I followed "Computergaga"'s tutorial on the web, which I found to be very good. However, even though I followed his instructions to the letter, it always returned a value of...

Hi Mr Excel, Good afternoon! First of all i would like to thank you for your uploaded video on you tube.i have learnt a lot having watched them. i was know nothing about excel,but your videos lot helped me to understand excel from basic to advance level. i was normal labor in company of...

Hello, I need an if statement with multiple conditions. I know that I should be using OR and AND in the formula but I have not clue how to write it but nor am I am even sure if it can include this many conditions. Below is what I need to be in the entire formula. If N2 = Mismatch AND O2 =...

Hi, The below macro does not help me to sort data. Can someone help me in to sort the data through macro or correct the below coding and help me to identify what the mistake is. Sub sorting() ' Sorting Macro 'CODING TO CHECK THE NETTING UPLOADED MsgBox "open Netting uploaded...

Hi folks, as the title says, how can I remove the $ and - from unused cells on my spreadsheet? I've uploaded a pic of what I mean - https://imgur.com/a/hsRQyPV Thanks again,

Hi there, I am trying to find the number of non-repeated (unique/frequency) family names in each grade. I have prepared a sample and uploaded to one drive. I would appreciate it if someone could help? https://1drv.ms/x/s!AgQdYsSdg735fXy_R4rJuVlmcuw

Hi, i am trying to create a master worksheet that can be updated when another worksheet is uploaded into the same workbook. what am trying to achieve is that if the text in column A of the uploaded worksheet matches column A of the master worksheet then copy value in column E of that row in the...

I have an ID field that is a number field but is not currency. The ID field needs to return results with a () around the results and not "-". This field is uploaded into Quicken and then from there it is uploaded into another system; this other system will not accept the upload if it is not...

Hello; Because of the CODE and HTML tags used for posting codes in the forum, the VBA code i have posted in the link below is not the same as i have posted. https://www.mrexcel.com/forum/excel-questions/1033472-extract-text-span-element-xml.html I tried to turn OFF and ON the tags but...

i have uploaded the file here https://www.dropbox.com/s/j491r6e5s6in3qu/Aladin.xlsx?dl=0 below formula does not work. =SUMPRODUCT(DataAMOUNT,--ISNUMBER(MATCH(DataYear,B$2)),1-ISNUMBER(MATCH(DataMonth,$A3,0)),--ISNUMBER(MATCH(LEFT(DataPRODUCT),{5,6,7}&"",0)))

Hi all, I am desperate for some help. I am trying to use the network days function to establish whether or not some data is late. This is fine, but I need to add a time to this too as anything over a specific time is classed as the following day (hence late). My spread sheet is as below...