number

Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a user. Example- "F" in a cell becomes "F:" A2 has to always be three digits- so if a user puts in "1", the cell shows "001" or if a user puts in "20"...

I have a workbook that gives me a number depending on cell color using Define Name. I named it GetColor. I used a previous post in MrExcel to do this. When I change the color, the number does not change automatically. What am I doing wrong? =GET.CELL(38,Sheet1!$B$2) This is what I am using...

I'm trying to write the following formula: =MAX('02'!C5:C18) But instead of referencing the sheet named "02" I either want to reference a cell that outputs the name or number of the sheet, or have it reference the current sheet (because there are 200 sheets just like this one and they are all...

Heya, im barely great at Excel, and im struggling to develop a formula. I have one sheet that has a Numeric result in ONE cell - S2 The number is ANY value, with ANY decimal point value I need to put a formula in another cell that defines a grade 1-5 based on its value S2's value. *Each Peak /...

Hi all. I'm trying to find the correct excel VBA code to count the number of columns in a named range, from the start of the range up to and including the current active cell location and return that value to a specific cell. Example: "mynamedrange" is columns AA thru AZ and the current active...

I am currently picking cells from another spreadsheet (MasterSheet) which is a flat row by row data set Column A to F 600+ rows. The Slave sheet I am using to create a more user friendly layout of the Master Sheet so same data but with a slightly different layout, with headers created from date...

Hello guru's. I have always struggled with loop...do and I need to do more study on this theory. CONCEPT: code that allows me to loop through a worksheet and move Manager Name (find d.value) to 2 rows above Store Number (find c.value). The data sheet has various rows in-between c.value and...

I'm looking for a way to determine the number of the color set to cell. I have a macro that loops through creating a column of cells with the number background color... But I can't seem to find the corresponding color from the fill drop down. I have a table and use the color number to set the...

Good Morning, I would like some help or advice with a basic excel spreadsheet I am to build. On a worksheet I have columns for week numbers and within each week number I am entering values. On another week sheet I have summary sheet where I want to display the current month's week number from...

Hey ya'll, Been tinkering a bit to see if I could get the macro recorded/cobbled together to do the following, and I keep hitting roadblocks in debug: 1.) Select several Sheets, and Ranges in each 2.) Have an Input box pop up, requesting a number 3.) Increasing the selected sheets/ranges by...

I am looking for a IF statement that will: In cell A9;Compare Cell D9 with K9 and show the greater number in cell A9 BUT If D9 & K9 equal each other then compare E9 with L9 with the greater number showing in A9 BUT If E9 & L9 equal each other then compare F9 & M9 with the greater number showing...

<tbody> A B 1 Part Number Name 2 ABC123 C1,C2,C3,C15 3 XYZ321 J1 4 IJK100 L1,L2 </tbody> Hello, I have data like the table above (with many more rows and longer names) and I need to break the Name column so that each name is separate with the Part Number listed next to it. An...

I have this formula below. I need to add and if statement to it that if the total is less than 4 (<4) then just put an 0 but if 4 or greater (>4) then show the number. =SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192)) Thank You, James

I have a column of data containing 24 rows. Rows 1-12 always contain positive numbers. Rows 13-24 can contain a positive number or are blank. All the blanks are at the bottom of the column, i.e., there are no blanks above a positive number. I would like to to obtain the last 12 positive values...

I am trying to use a macro across a number of worksheets in a workbook I am not very good at writing VBA so just record it but from some reason the macro just references the one sheet how do I change it so that it doesnt just look for the same sheet all the time? Also the number of rows varies...

Hello all, I have a tricky problem that I can't solve, and I would like help from more experienced people. I have a gantt chart to show the progress of tasks by user. Bar colors are made by conditional formatting, but each cell that is painted also has a value of "1" (while unpainted cells...

I have a vba enabled workbook (Excel v2013), and now every time I add a new worksheet the number format setting has defaulted to "Date". This is causing many issues. I can't find the option to reset the default to "General". There is one macros enabled on a few sheets to adjust formatting within...

I have a macro which doesn all that I need except with the new worksheet name. the name is relevant to a figure in the cell E9. The number in E9 is formatted as a four digit number so if 21 was typed in the cell reads 0021. Unfortunately when the new worksheet is created using this number it...

Hello everyone! i need to make a report with the number of times that a user buy a product... the report must be separated into ranges, and the number of IDs varies from 1 to 20 in the table. im working on power bi; maybe i need to use a measure? i leave a img of my idea. THX nwn <3...

Hello,</SPAN></SPAN> In the cell H6 I have a formula =COUNTIF(D$6:D$100,G6) which start counting unique data of column D from the starting row 6, I need help how can I change starting row number 6 to x row "in the formula above which I am running via VBA" does it is possible VBA formula can...