Domski
Forum Guru

Hi Dom,
I just found your profile, I have posted a thread about trying to create a Macro that copies selected rows into a single sheet. I was wondering if you could help me at all I am very stuck?

Thanks
Ash

i need help with the date time stamp:
when i type data in A2 i want B2 to automatically add in the time and the date, ive gotten this to work - only problem is when i drag the formula down and i type info in A3 etc it changes all the dates and times to the current date and time, i need each date and time to be different and to be as per what was filled into A2, A3 etc and not change.... please help

Hi Dom,

Could you help me witht the forecast formule
H has the range from 0.3 to 0.6 and A has the range from 2 to 11, in the middle are factors correlate with A and H at the same time,
I use the FORECAST function to find any value of A let us say 4.6 but just correspond to certain value of H $C$3
=FORECAST(F15,OFFSET($C$3,MATCH(F15,$B$3:$B$16,1)-1,0,2),OFFSET($B$3,MATCH(F15,$B$3:$B$16,1)-1,0,2))
when I tried to apply it for the H values , it does not work well becasue of the values -1,0,2) , could any one help me please?

Regards,

Hi again Domski, I've tried to make things a bit easier to work with here - do you think this will work?

Hey Domski,

Thank you for all your help so far - do you have any further suggestions as to how to make this work?

Hi Domski

Is your avatar a beaver? if so Castor canadensis or Castor fiber?

Alf

But i can inform the user that they are violating the rules right?

Does any infraction reduce the reputation?

I am pretty new to the forum and have a question. Why is it that some infractions are yellow while others are red? Some show Infractions 1/0 (0) while others show 0/1 (1) ? How do i post an infraction if i see that someone has violated the rules?

I have a columne with 45000 cells and some of them are repeating and I want to get two columns; one containing only different cells from those 45000 and right next to it column showing how many times every of differetnt sells from 45000 repeated in 45000.

Hi Dom,

Please have a look at my last post on custom lookup 2:

http://www.excelforum.com/excel-gene...ml#post2599642