great

All, I have created a name in the name manager I called it "l3nox". The data can be pulled how ever I want it to so the amount always changes. I then graph the data based on the name I have defined. Here is the equation for my name. =Sheet1!$F$6:INDEX(Sheet1!$F:$F,COUNT(Sheet1!$F:$F)) For...

Hi, Was wondering if anyone could take 5 minutes to review one of my spreadsheets. I have completed it to a good standard but was wondering if any one could provide feedback? It's not very complex so doesn't require a genius, although any help would be great! Thanks,

Hi I assume I need a Count and/or Sum formula if the letter "S" is found in "I4" and also "A" is found in "F4" (both found not if/or) then use value found in "AP4" Any help would be great Stephen

I'll start by saying, I'm not good at all with VBA - but if you have easy to follow instructions that would be great A user of mine, has a spreadsheet with around 300 linked documents in a spreadsheet. The problem being, the documents are either on their own desktop, or a couple of other...

hi all. is there a way to perform the following? in range sheet 2 H22:H39 look for value Sheet3 B3 and if that value is between sheet 3 L11 and M11 return 1, otherwise return 0. also, the values in these ranges are times formatted as h:mm any help would be great. thank you. EDIT..... now I...

Through the help of many on this site I created a worksheet that you can add an embedded PDF or other type files and this works GREAT but now for some reason I have 1 excel file with an embedded PDF that just will not open... clicking on the embedded file does nothing... there are embedded .JPG...

=IF(F14="cancel";0;((D14*12)-(ABS(E13)-(D14*12)))-.... Please help! I seem to be stuck. The following formula doesn't seem to be working, but I can't figure out how to fix it. 1. The excel is aimed towards payments. Some pay in advance, which means that they have money "left over" for...

I have searched and cannot find a way of doing this. I need to list the folders and count the subfolders within that folder, but stop there. I don't want to count the sub-folders sub-folder. An output like this would be great <tbody> Folder Sub Count 2018 52 2017 1005 2016 1235...

Hello, I found this formula online which returns a blank cell if the VLOOKUP doesn't find anything in the 3rd column instead of ZERO. <code> =IF(LEN(VLOOKUP(A1,Sheet1!$1:$1048576,3,FALSE))=0,"",VLOOKUP(A1,Sheet1!$1:$1048576,3,FALSE)) </code> The formula works great but need to add an additional...

Here is my Google Sheet, you can show your magic here. It would be great if you explain how your formulas works in layman's terms. Thanks!

I just recently have been having Excel crashing a lot. And some times when I create new Workbook it gives the unsaved workbook the name: "Book1 Non Commercial Use Unlicened Product. But then other times this does not happen. I can find no consistency in this happening. Anyone have a answer...

Hello, I am trying to count the number of occurrences (i.e. # of flights) per day based on the date and location. The table that the information is populating is laid out in a monthly fashion so row "A" is filled with the days of the month. I have tried to use the following countifs statement...

Can one change a font in slicers? Seems my tables look great but the slicer font is huge.

I have a question regarding Array Formula 6 around the 29:00 mark in the youtube video. I put in all 3 formulas for sales team 1 and the only answers that I got was 0 and the total autosum for the for the entire sales table. I am just trying to get sales team 1 total sales. I will great...

Please could somebody help? I am trying to use a simple condition of Great than or equal to. The complex part is that I want each row (217 of them) to check whether they are great or equal to the corresponding row but it wont work. Thanks in advance for your help

Hi, In a process, a value first decreases and then increases back up again, over time. Would be great if someone can help me calculate the time when the value is increasing and has gone past a certain level. So for example, in the following example, I would like Excel to return "7 hour"...

I need a not equals formula for a cell. if cell A does not equal the sum of cell B and cell C. Cell A will turn red. any help would be great thanks

Good day all. I am using excel 2016 I am trying to do a seemingly easy IF formula but every way I write it I get an error What I am trying to do is as fallows: IF any cell in Column J = 1 then I would like cell F1 to subtract the value in cell H1 Any help would be great. Cheers

I have noticed that in some spreadsheets Excel will automatically copy formulas (and formatting) from the previous row. This is a great feature, but doesn't behave consistently. Does anyone know the rules or conditions under which Excel does this?

Trying to get this to be blank when no data has been entered. Currently, if there is no data put in yet it puts up an L =IF(A2="","",IF(A2>2500,"H","L")) any help on this will be great.