Get instant free expert help with Excel and Google Sheets

drop down to update data when selected,check for any duplicating values in colums and print the resultant on a dash board

Hi I have multiple sheets with name which is present in main data sheet in different workbook. I need to paste data to corresponding sheet with the same name

I need a formula for the drive spreadsheet to return the date of the first day of the month and the day from the start of the week. For example, every month one should be 01-07-2018 then 01-08-2018 The other should change every week 01-07-2018 to 08-07-2018 to 15-07-2018

I am having trouble with pulling data from one tab to the other. I am trying to sort and only show one set of data at a time.

i want to have the following formula to recognise >=2.5 to <2.75 without lower than 2.5 being recognised.

HI I am trying to use a Query formula in excel to extract students names onto a separate sheet for each student the below formula wont work in excel. can you help? =query(Sheet7!A3:AE,"Select * where B = '"&A1&"' ",0)

I need help applying a formula to the rest of the columns in my spreadsheet

I'm trying to calculate difference between two cells in the following format (date, time)

I want my sheet to take my excel sheet with adresses that have lat and long and using a matrix calculate the distance between the lat and long of another place

Help... I have been given a formula but I can't apply it to the cells