Topic profile page for Dynamic Range.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Dynamic Range.
Topic "Dynamic range" was discussed 21,524 times on 1,705 sites in last 3 months
Started 2 days, 11 hours ago (2009-12-02 20:33:00)
by DT_User
Summing a dynamic range I need to sum ranges of different sizes. I do not know how to sum and display the values of each range. Can you please help with the code? Below is my data set. I need a macro that creates the sum of column B row 1-6 in row in row 7 then the sum of column B row 8-11 in row in row 12. Thanks for your help...
Started 2 days, 19 hours ago (2009-12-02 12:14:00)
by dems
Setting a dynamic range? Hi guys, I would like to set a range to a variable. But rather than fixing the range, I hoped to made it dynamic so that it would count to the last row in the column. Is this possible, and if so anyone care to demonstrate to me how? Many thanks, D
Started 3 days, 2 hours ago (2009-12-02 05:30:00)
by hackint0sh
via MacNN: Pictional has launched a new High Dynamic Range (HDR) utility for the iPhone, TrueHDR 1.0.1. The app creates HDR images by blending two similar images, captured at different exposures, for an increased tonal range. iPhone 3GS users can take two images within the app, while all iPhone users can select saved images to blend.... More...
Started 3 days, 11 hours ago (2009-12-01 20:17:00)
by goldenbear10
Hi, I have a formula that functions in a similar manner to vlookup, but instead of returning the next smallest value, it returns the next largest value. Here is the formula, which is located on Sheet2: Code: OFFSET(INDEX('Sheet1'!C7:D11,MATCH('Sheet1'!$C$24, 'Sheet1'!C7:C11),2),1,) The part of my table in which I am interested is C7:D11, and ...
Started 3 days, 23 hours ago (2009-12-01 08:18:00)
by penfold
Hi I am using the following formula as a named range in a pivot table. =OFFSET(OrganisedData!$A$1,0,0,COUNTA(OrganisedDat a!$A:$A),16) However the range seems to be picking up 1 blank row at the end of the data which is then pulling through as an #DIV/0! in my pivot table. Any ideas how I can make the range stop at the bottom of the data? Thank...
Started 4 days, 4 hours ago (2009-12-01 03:54:00)
by goldenbear10
Hi All, I have the following situation in excel 2007: In Sheet A I have: Input Quantity Input1 3 Input2 2 Input3 4 I want to sum the range under quantity, but there is a macro that allows the user to add more inputs, such as (input4, input5,...,inputn). How do I create a formula (or macro) that ...
Started 2 days, 16 hours ago (2009-12-02 15:31:00)
by dems
Re: Setting a dynamic range? Quote: Originally Posted by pgc01 Hi Example with 2 options in vba: 1 - you have a range of contiguous cells starting in C3, down 2 - you have a range of non-contiguous cells (blanks in the middle) starting in C3, down. In this ...
Started 2 days, 10 hours ago (2009-12-02 21:17:00)
by DT_User
Re: Summing a dynamic range I know about subtotals and the AAA Total and BBB Total are already subtotal lines of a different column I did not show you. The problem is that I need to do additional math on the subtotal (I need the sum of the set then divide that by 2) Is there a way to add the divide by 2 too the subtotal value ...
Started 3 days, 21 hours ago (2009-12-01 10:24:00)
by DonkeyOte
You don't specify the data type returned if non-blank... Presumably you're using some sort of IF to populate with Null if blank ? I say that because Null is seen as non-blank by COUNTA etc (0 length text string) If you're column A contains Text strings then try replacing the COUNTA section with: COUNTIF(Data!$A:$A,"*?") If returning Numbers then simply use COUNT(Data!$A:$A) + 1...
Started 4 days, 3 hours ago (2009-12-01 04:51:00)
by goldenbear10
That did work, thanks JBeaucaire. Except, I would like to paste the result in another cell which is located in another workbook, but the Selection.Copy part of my code doesn't seem to be working: Code: Sub mymacro() Application.Workbooks("Book1.xlsm").Activate Application.Sheets("Sheet1").Activate Dim LR As Long 'the lastrow in the region LR = Range("C13").End(xlDown).Row...
Started 1 week ago (2009-11-27 10:54:00)
by MtnSurfer
The puropse of this kind of processing is to increase dynamic range and show the viewer a closer representation of what the human eye actually saw at the time of capture. HDR is very easy to overdo which can make pictures look like water coloring, unnatural or cartoonish IMO - not what the human eye saw at all. Unless of course one likes that look. I actually prefer doing manual ...
Started 1 day, 20 hours ago (2009-12-03 11:30:00)
by Bovineguy
No, CS 4 is very good at combining HDR images, but Photomatix Pro 3.0 is the best. I it will combine the images, and then allow you to tone map your images then export in to Photoshop to finish them off. Just make sure when you are shooting images for HDR that you only change the shutter speed. If you change the ISO, you will be adding grain, if you change aperture, then you change the ...
Started 1 week ago (2009-11-27 08:55:02)
by th_parts
Thanks everyone... Autotone has never done the trick for me either Fletch. And you're right that its not the solution for every pic. But I have a pretty good idea for wich it is a good start of the proces and wich not. Mauricio; I will certainly check that out. Can you hint me where to look on the site?
Started 1 week ago (2009-11-27 08:34:38)
by philipstorry
zuiko3 If I recall correctly, the Kodak sensors have a slightly lower DR than the newer E-3 sensors. However, the newer cameras seem to meter more for highlights, leaving loads of room in the shadows. The Kodaks were the reverse. The combination of metering differences and the changes to the colour curves in the JPEG engine explain most of the differences you'll see from ...
