I have been tasked to convert inches to mm in a huge excel document and I am only able to convert once cell at a time and I would like to be able to convert everything at once or a cell range.
Converting formula I have is =CONVERT(2.75, "in","mm")
Is there a way to use that in a range rather...
I hope you can help me.
I have created a workbook in VBA in order to calculate marks for my class. It uses multiple worksheets from which data is pulled in, in order to come out with a final grade for my students. I introduced the program to my staff, and they loved it. Now I am...
Well, either Excel 2010 operates very differently from previous, or I have forgotten a huge amount about working with conditional formats.
I have two columns (J & K) with dates in them (Formatted mm/dd/yyyy).
If the date in column K is later than the date in column J, I want the cell to turn...
I am trying to change the formulas that are in several hundred cells all at once. Every formula's cell reference needs to increase by 140. (i,e, if cell b1 has the formula "=Mon!D20" it should say "=Mon!D160") Is there an easy way to do this with retyping everything?
Not all of the...
I have a large spreadsheet I'm working on and here's what I want to do:
IF a particular cell has "x" value in it, then I want to multiply a corresponding cell with a pre-filled in dollar value by .45 and place that calculation in a different cell.
If cell A1="636" then multiply the...
Hi, I would like to generate a string by concatenating cells from a header (first row of cells), based on whether the cells beneath the header meet certain criteria.
For example, in the worksheet below, the number 2 is repeated beneath the headers c, 1, 2, 3. So, the formula I need should...
So I need to extract numbers from multiple cells withing a range, having added them up. The current extract number function I found only works for one cell at a time.
Function ExtractNumber(Target As Range) As Variant
Dim i As Integer
Dim str1 As String
For i = 1 To Len(Target)
I am trying to do a formula to count the number of rows that have a certain value in two different columns.
For example, if the person in row 1 has a value of 3 in column b and 1 in column c, I want them counted.
I have done =COUNTIF(B:B,3)+COUNTIF(C:C,1), but that counts all of the people...
Hi guys, Im trying to show the three largest numbers.
=Large((A1:C1,F1:H1),(1,2,3))The following works but a want it the simplest possible
I am trying to map an XML elements to multiple cells in a workbook and MS Excel is not allowing this.
I would really appreciate if somebody can tell me of how to do the multiple cell mapping.
Hi All, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I am trying to import XML data to different sheets in a workbook.<o:p></o:p>
Is it possible to map an XML element to multiple individual cells and repeating cells in a...
I am very new to VBA and am trying to write a simple procedure which will "record" the formulas from 130 adjacent (dimensions: 1 row, 130 columns) to memory.
Then I want to multiply all the formulas by a factor, record the change in an output variable and finally replace the altered...
I'm new to all of this, and it can become a bit daunting at times, but what I'd like is some help in setting up a formula to enable the correct reference when multiple cells are used as references.
As you can see, I have 4 divisions in a local eight ball pool comp.
Within each division...
I need to create a formula that will check 3 separate cells (K2,N2,Q2). If K2 has a value in it and no values in N2 or Q2, then it would return a 1. If K2 & N2 have a value and no value in Q2, it would return a 2. If K2, N2 & Q2 all have values, it would return a 3. If K2, N2 & Q2 are blank...
Hello, I have multiple cells that contain 5 set of numbers that are separated by dashes. Example: 10-11-17-20-26
These set of numbers are on 1 cell only. Exp: A1
I would like to separate these numbers. I would like 10 to be displayed on A1, 11 on B1, 17 on C1, 20 on D1 and 26 on E1.
Hi everyone -
I currently have a working Excel Workbook that I am using to search multiple cells for an array of strings. I have condensed the strings in the array for purposes of posting on this site (there are dozens of strings to search for). Ideally, I'd like to put all the text in the...
I need a formula that states if cell F8=3, then K8, P8, U8, Z8, AE8, and AJ8=0 (if F8 is any other number, the other cells are left blank).
I can't write the formula with K8:AJ8, as there are hidden columns in-between with other formulas. HELP?
I'm making a worksheet witch included a popup calendar. So when I select a cell with tab, the arrows or by clicking it, it calls my macro. It's a macro named "OpenCalendar" that I previously made witch works fine.
My 1st question is, how can I call my macro for a long list of cells. Here's...
Hi, first off I must apologize for being new to this. I'm having an issue, similar to some I've seen here. First problem: I'm trying to Highlight duplicated cells across multiple (6) worksheets. The data is always in column 4 and it has to be exactly the same for it to highlight. Second...