can you tell me where its located

i need to calculate the speed of a car if it is travelling with a weight of a passenger at 60kg and the car travels a distance of 600km in 4.30hrs.

is there a way the i could create a formula that would check the current date and then set the date to monday of the week. examples: on date 07.Nov 07. The...

Thank you for reading... I am having an issue with sorting by numbers: example of issue: 58849864 55465978 54668976 54668978

Can I change the range from cells to sheet in following. I have problem when data is bigger than range that macro currently selects, only sorts to 159th...

Please help me!! how to delete row where the row is not coloured

Hello guys, i have created a form using Visual Basic, however i have a problem, just for presentation reasons problem. When the form comes up, in order to...

I've managed to match two columns (B + K) and return the value in a third column (D) using the formula below. =INDEX(B2:L1204,MATCH(K2,B2:B1204,0),3) Here's...

I have 10 work books 7 columns in each of 60 to 100 rows (variable). The last column counts the work a number between 1 and 20. How can I select only the rows...

I have a workbook with 3 sheets in it. Occasionally one or more of the sheets will not scroll up or down from the cells viewed on the screen. the scroll...

A B C D E 1 1 2 3 4 5 2 361 311 296 247 303 3 596 562 234 979 536 4 5 Say cell B5 contents 4. What is the formula to sum columns with no...

I have some data, which containing is "Reg. no., Roll no., Name, Add. " etc. in each column, in sheet 1, and another sheet there are some data, which...

I have a column of some 10.000 values with duplicates highlighted; now, I'd like ot have all of these duplicates ( not just a list of distinct values) stored...

I have some data, which containing is "Reg. no., Roll no., Name, Add. " etc. in each column, in sheet 1, and another sheet there are some data, which...

Hello In this spreadsheet we have pairs of columns for each week-ending date. Let's say that week 1 uses Columns C&D. Each Row represents a store. Columns C...

Hi everyone, Well! I've been trying to add to the formula supplied by Frederik and Joe so that a blank " " will be returned if A12 is blank. Can anyone help...

hi i am going to convert numbers to words. for example: 12345(twelve thousands, three hundred,forthy five) is that possible to do that? if it is possible pls...