Search results

Hello All, We have a dataset, contains numeric figures are custom formatted as Debit "Dr" and Credit "Cr". We want to extract/ filter that numbers as Dr or Cr. Kindly help us. Thanks in advance.

Thank you so much Alan. Can it be done through formula, I mean other than power query? I want just below result. I will select the date and extract values and other row. Thanks once again. Date 05-02 WIMS_STATI Value APGW_31846 10.08 APGW_3948 6.11 APGW_4903 7.75 APGW_3722 5.33...

Looking for formula to extract date wise values from the table to a new table. Sample file is attached. Thanks.

Without borders and colors?

This is Working fine. Thank you so much. Do you have solution other than VBA?

Hello Everyone, I want to extract data from a table, Where I select an item, it will extract the available place and amount. Attached kindly find the file. Many many thanks in advance.

Thank you so much Sir, with great pleasure.

Sir, Thank you so much once again. I have been done same after getting your help. But it was showing address when I hover over them so is there any vba code that hyperlink them but do not show the address?

Hello, I want to change the mouse pointer from (plus sign to arrow or something) in excel through VBA. I have a range of cells data and each cell is hyperlinked through VBA. But the cursor point is plus sign which I want to change and can understand the data is hyperlinked. Please help me and...

Perfect Sir...Thanks a lot.

Exactly Sir... thank you so much for your help. however, I am attaching my demo workbook..

Details? I need a selection help, that when we click in a project in sheet1 it will select the same project name in the sheet2 from drop down list. Once it is selected then project details will show. project details will be extracted from the raw data which is in another sheet and that we can...

Attached please find the workbook...

Dear Sir, Greetings! Kindly help us regarding hyperlink while selecting a project name in the worksheet it will open in other worksheet and show the details of that project. Example : We have a workbook which contain the name and detail of projects. In a worksheet, we can sort through...

If it is happen today, the result would be completed. Thank you sir.

Sir Attached please find the file and Thanks in advance.

Sir, It is working fine sir, do you have any easy to learn formula?

Thanks in advance.

Its working fine sir, Thanks....

1st row extracting WO Cost instead of Tender Cost.

Attached please find. Thanks in advance.

Attached please find and help me. Thanks in advance.

I have a database like this: City Project Status Amount A Project A Open 3419 A Project B Closed 5407 B Project C Progress 2351 A Project D Closed 2185 B Project E Open 5501 my requirement is like this: In a data validation under City 3 option A, B and "All". If I select Äll, it will count...

Dear Somendra, thank you so much for your continuous support. We always solve our problem through your best knowledge. Thanks once again. Best regards,

The minimum number of teachers for school category 1 if students are more than 200 is 5