combined

Hello, I have a VERY large file that I in summary need to find a number between a range of cells. So Column A I have a low number Column B I have a high number (goes to row 1,000) and need to know if this other number (column C) falls between ANY of those ranges. See below for a small snipbit...

I have a spreadsheet that has 4 tabs (Year1, Year2, Year3 and Combined) Within each tab is hours and dollar amounts in each column The top row 1:1 sums all the information within the columns it is associated with So column A2:A1000 Has Dollars Column B2:B1000 has Hours Column C2:C1000 can...

Thank you for your help! Using excel 2007. need to combine like pairs and keep the results in one row. A1:AK1 holds the pairs -The pairs are generated by a formula and are not sorted. The format is general and there are no duplicates in this row. A2:indefinate2 (as far right as it needs to...

Hi All, Can someone help an idiot with the combined formula, :) TIA

Hi, I was wondering if there is something that could be put in an excel sheet, probably an event code macro I think they are called, that could give a pop-up message right before someone exits out of the file, basically giving them reminders of things to do before they close the file. If someone...

hi i have several pdf files in one folder. i want to convert them into Word docs individually (not combined) through VBA. is anyone can help me out. heaps thanks in advance

I have two groups of data that I want to calculate the combined median for.One group has 4,094 sales with a median of $573,139 and the 2nd group is 1,259 sales with a median of $2,023,814.How do I calculate the median of the combined groups?Thanks

Hi everyone, I have found useful tips and shortcuts on this website before. This is my first time posting on the forum and I don't really know how to script in VBA (or any other language) or how to use PowerQuery. So I have a task/question that may be rather simple for intermediate or advanced...

The macro below combines several source sheets to a report sheet called "Combined." The macro works fairly well, except the value results in column A and B of the "Combined" sheet is returning the wrong range size based on each of the respective source sheets it pastes from. The range size...

Hi. I previously got help with a code. I modified it to use it several times, about 10 times. The question is: 1. Instead of pasting the code for every single operation and run it, i want to paste them all and run. The code is two ex: Sub test() Dim rng As Range, i As Long i = 3 For Each rng...

Hello I am trying to create a scheduling calendar. I enter the Monday's date for the week in cell B3 - I want it to return the "day of week and date" for example: Mon - 12/12/15 in cell b5 Tue - 12/13/15 in cell f5, etc...for Wed, Thu, and Fri Is there a simple formula to accomplish this...

Hi, I am using a sheet in excel which pulls data out automatically from a database. Fills in maybe 20 or so columns with orderinfo. In column A i have a unique order no. What i want to achieve is adding a column for an example C that is static. I fill in a number related to the order and i...