如果Sheet1!D2:D40中的任何囚室都含有“COMPLETE”,我需要F(row)从那张照片中将其内容复制到Sheet3!B(row)。 我用=IF进行了尝试,但是这给39个百分数的人提供了。 我需要Sheet3的囚室保持空白,直到满足Sheet1的上述条件。 之后,我需要他们(按条件要求)继续补足。 i.e.,如果说是真的1! 页: 1 B1. 然后,如果Shet1!D17是“COMPLETE”,那么Shet1! F17应当复制到Shet3!B2等。
我清楚地看到(ESPECIALLY with Excel/VBA),但我确实理解方案拟订概念。 我感到,可能有一些阵列功能,我不熟悉这样做。
I ve tried =IF(Sheet1!$D2:$D40 = "COMPLETE", Sheet1!$F2, "")
That was useless.
我在VBA中尝试了几处红十字与红新月联会的改动,但取得了同样的结果。
你们可以取得与工作单公式相匹配的结果。
=IFERROR(INDEX(Sheet1!$F$2:$F$40, FILTER(ROW(Sheet1!$D$2:$D$40), Sheet1!$D$2:$D$40="COMPLETE")-1, 1), "")
For an Excel formula I need the first cell out of a list of cells which contains a numeric value: A | B | C | ... | Z | ----------------------------- | 0.1 | 0.4 | ... | =0.1 | | ...
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
Does anyone know how to convert an Excel date to a correct Unix timestamp?
I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
I have created an Add-In in C# that implements user defined functions for Excel. These UDF s return immediately, but they control background asynchronous procedures. These procedures have status ...