“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have a data worksheet and several report worksheets. The input tab is constantly changing and being updated, but the reporting sheet do not dynamically change. An array and paste link don't fully provide the fluidity I would like. I need advice on how and what would be the best approach.

Solved by T. J. in 15 mins

I need a formula that says:
- if the total shown in D17 is less than $23.79 then return Yes in D18 and enter $23.79 in D19
- if the total shown in D17 is more than $23.79 then return No in D18 and copy the value in D17 to D19
The value in D19 is then added to the value in anther cell to get the total amount chargable to the client

Solved by C. Q. in 23 mins

Column A has a date column B has a later date . Is there a way of calculating the number of weeks in between?

Solved by M. H. in 29 mins

I want to create a interactive dashboard with slicers in excel 2010. I have charts that are already created without pivot tables. Is this possible to do with the existing charts that are not pivoted?

Solved by X. U. in 29 mins

I can not share an excel document as it says i have a connected account and i need to delete it in settings ? There is non connected though ?

Solved by A. Q. in 11 mins

I need to extract a specfic letter/number combination from column A but the only consistent character is "x", i.e. 4x8.

Solved by K. J. in 22 mins

In the work register I inputted quarterly numbers using a formular. what formular can I use for year to date please

Solved by F. D. in 23 mins

Need help writing an IF Function formula for the Comments Column O. Here is what is needed: Use the IF function to complete the "Comments" column of table 1. Display "Good Job" if both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the assessed "Quality" of that project is greater than 1. Display "Too Much Time" if the "Hours Worked" on a project exceed the "Estimated Hours" for that project; otherwise, display "Poor Quality".

Solved by F. J. in 21 mins

I have a long dataset from one external company excel sheet that i am trying to get sales values for per barcode. But the actual data comes from another sheet.
I have created a pivot table in the "other sheet" with the number of sales per barcode which are A-Z listed. Is there a way to match the barcodes up with the number of sales but keeping the order of the barcodes in the external spreadsheet?

Solved by I. J. in 26 mins

i want to buy a boxed version of excel 2010 for a mac at a reasonable price. is this impossible?

Solved by M. S. in 22 mins